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 “carwashes” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
carwashes174577(None) 
calashes13310532ca_lashes
carcases12313082carcas_es
carcasses1337462carcasses
caroaches1637792caroaches
carwash1535992carwash__
crashes124618402c_r_ashes
abashes12510373_a_bashes
acariases1146613acarias_es
arrases71214543_arras_es
backwashes24104673backwashes
barwares13610093barwa_res
brashes124518463_br_ashes
calabashes1742903calabashes
calipashes1742453calipashes
camases114216343ca_mas_es
camasses12388973ca_masses
canvases13349513canvas_es
canvasses14286033canvasses
capiases1239253capias_es
carafes125015703car_a_fes
carates95630603car_a_tes
carcase11312733carcas_e_
carcass11310513carcas__s
cardcases1446493cardcas_es
caresses10314063car_esses
carfares13310323carfa_res
caritases1139743caritas_es
carnages11312213carna_ges
caroches15710693car_oches
carouses10614503carous_es
carroches1665893carroches
carses85233653car__s_es
cartages11313313carta_ges
caseases10410473caseas_es
cashes114729883c___ashes
catfishes1746303catfishes
cerastes101111093cer_astes
charases131312753char_as_es
clashes124017283c__lashes
crases85532313c_r_as_es
crashed134214203c_r_ashed
crasher124616153c_r_asher
crashers134013223c_r_ashers
crawfishes2143593crawfishes
creases94020963c_reas_es
creeshes1336953c_reeshes
crushes124215133c_r_ushes
czardases2143033czardas_es
earaches13411303ear_aches
earwaxes1844703earwa_xes
eyewashes1842163eyewashes
flatwashes1941943flatwashes
gamashes1456943ga_mashes
garfishes16167083garfishes
garnishes13198813garnishes
harasses11311033har_asses
hardasses1346453hardasses
hogwashes1942463hogwashes
kurbashes1883523kurbashes
lavashes1445573la_vashes
marishes13512553mar_ishes
marshes123615373mar__shes
oarfishes15156953oarfishes
outwashes15116183outwashes
parishes13314753par_ishes
pearlashes1543253pearlashes
prewashes1744753prewashes
radwastes1364123radwastes
rainwashes1642763rainwashes
rashes95330153__r_ashes
rewashes1447033_rewashes
swashes134714403__swashes
tarbushes1444883tarbushes
tarnishes12188893tarnishes
thrashes1487653thr_ashes
trashes104119253_tr_ashes
varnishes15207913varnishes
washes124425493___washes

Search took 9 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 Filter1786911486410.1731032896.0
2DLD Change Limit148641798.57617332.2
3Display Results79790.0332393.9
 (SQL Overall)178691798.78220347.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.