Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “parasailing” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
parasailing144433(None) 
parasailings1552181parasailings
assailing1036023_a_ssailing
boardsailing1651493boardsailing
paraffining2052353paraffining
paragliding1652943paragliding
paralleling1463103paralleling
parasail1049233parasail___
parasailed1344073parasail_ed
parasails1147583parasail__s
parasang1147333parasa___ng
parasitising1553463parasitising
parasitizing2454043parasitizing
parboiling1545173par_boiling
prevailing1656723p_revailing
resailing103314253__resailing
travailing1444613_travailing
wassailing1443593wa_ssailing
abseiling1265344_a_bseiling
airmailing1343634_airmailing
arabizing2147964_ara_bizing
archaising1645104_archaising
archaizing2545224_archaizing
assoiling1045354_a_ssoiling
availing1267284___availing
bargaining1445214bar_gaining
berascaling1652484berascaling
boardsailings176934boardsailings
brailing113514794_br__ailing
brasilin1046964_bras_ilin_
brasilins1146244_bras_ilins
caracoling1545634cara_coling
caracolling1643034caracolling
caravaning1644434carava_ning
caravanning1752374caravanning
craaling112711354_cra_a_ling
curtailing1344604cur_tailing
derailing112011314der__ailing
faradising1545274fara_dising
faradizing2445934fara_dizing
harassing1346984haras__sing
kraaling13186664_kra_a_ling
marshaling1645084mar_shaling
marshalling1753214marshalling
outsailing1137564_outsailing
paganising1445954paga_nising
paganizing2347274paga_nizing
palatalizing2454894palatalizing
palisading1443894palisa_ding
panbroiling1652564panbroiling
parachuting1952514parachuting
parading12313864par__a_ding
paragoning1445954para_goning
paragraphing2152354paragraphing
parallelling1571994parallelling
paralysing16235554para_lysing
paralyzing25185204para_lyzing
pararosaniline167994pararosaniline
parasangs1246034parasa___ngs
parasitic1349524paras_iti_c
parasitise1277404paras_itise
parasitism1466594paras_itism
parasitize2165864paras_itize
parawing14310584par__a_wing
parbaking1877204par_ba_king
parbuckling2251464parbuckling
parceling1438444par__celing
parcelling1546174par_celling
parlaying1537304par_la_ying
parling103823764par____ling
paroling113316214par___oling
parsing103819554par_s___ing
partaking1698674par_ta_king
passaging1345614pa_ssa_ging
passalong1242524pa_ssa_long
periling11316864per___iling
perspiring1544854per_spiring
pertaining1347994per_taining
phrasing1438014phras___ing
practicing1775584p_racticing
practising1586364p_ractising
praising113214564p_r__aising
prattling1246304p_ra_ttling
preboiling1546404p_reboiling
prefiling1549534p_r_efiling
presaging1339394p_resa_ging
preselling1338694p_reselling
presiding13510904p_res_iding
preslicing1546364p_reslicing
profiling1548234p_r_ofiling
pyramiding1943534pyra_miding
railing83325644__r__ailing
rassling939014__ras_sling
reassailing1244104reassailing
reavailing1444874_reavailing
remailing122412474__remailing
renailing102813334__renailing
resiling93520174__res_iling
retailing103214734__retailing
sailing83927374____sailing
stravaiging1652124stravaiging
trailing92916094_tr__ailing
unavailing1443374_unavailing
warsling12198594war_s__ling
warstling1335064war_s_tling
wrassling1334274_wras_sling
wrastling1335524_wras_tling

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911488190.406440125.6
2DLD Change Limit1488191078.62617252.4
3Display Results1071070.0462326.1
 (SQL Overall)1786911079.07819684.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.