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 “croupily” 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.

94 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
croupily154474(None) 
roupily1246651_roupily
choppily2044132choppily
cloudily1444282cloudily
creepily1574952creepily
crispily1574692crispily
croakily1744732croakily
croupier1246882croupier
croupy13458732croup__y
crousely1346562crousely
crusily12199092cr_usily
droopily1443942droopily
ropily113312442_ro_pily
blousily1345193blousily
broodily1445503broodily
campily1638273c_ampily
chirpily1843773chirpily
cloggily1543243cloggily
cockily1838493c_ockily
compile13312443c_ompile
comply152810383c_omp_ly
cornily12410853c_ornily
corruptly1643093corruptly
cosily113613853c_o_sily
couping124317023c_ouping
couple104415963c_oup_le
courtly1256923c_ourtly
cousinly1345933c_ousinly
cozily20349703c_o_zily
crabbily1744343crabbily
craftily1644783craftily
craggily1543703craggily
crankily1755623crankily
crazily2136923cr_azily
creakily1735393creakily
creamily1536363creamily
crisply14426523crisp_ly
croppie13278793croppi_e
croppies143111133croppies
cropping153210883cropping
crossly1277273cro_ssly
croup95616783croup___
croupe105114433croup__e
croupes114613103croup_es
croupiers1334653croupiers
croupiest1337063croupiest
croupous1245923croupous
croups104312553croup__s
crucify1744063cr_ucify
crudely1336273cr_udely
crudity1336043cr_udity
cruelly1236563cr_uelly
crumbly16347523cr_umbly
crumply16336093cr_umply
crustily13328173crustily
dopily123510463_do_pily
drippily1643033drippily
drowsily1583723drowsily
floppily1843773floppily
frostily1436693frostily
frothily1745303frothily
frowzily2642673frowzily
frumpily1843323frumpily
goutily1137933_goutily
groggily1443283groggily
grouchily1842843grouchily
groupie1045783groupi_e
groupies1137523groupies
grouping12308533grouping
grumpily1643463grumpily
loopily1236803_loopily
lousily1038333_lousily
mousily1239393_mousily
preppily1444593preppily
promptly1743913promptly
prosily12611633pro_sily
proudly1336333prou_dly
roily86121113_ro__ily
roomily1237283_roomily
rosily93914713_ro_sily
roughly14507293_roughly
roundly1136723_roundly
roupier9319493_roupier
rouping103715793_rouping
roupy106112713_roup__y
rowdily1436083_rowdily
scrappily1842673scrappily
scrimpily1842553scrimpily
sloppily1544613sloppily
snoopily1345553snoopily
soapily1237963_soapily
troupial1044183troupial
troupials1142933troupials
trouping11249503trouping

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 Filter1786911461620.420425454.8
2DLD Change Limit146162947.64319123.6
3Display Results94940.0303133.3
 (SQL Overall)178691948.09322079.7
 
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.