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

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

71 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
crowds12491076(None) 
crowd115815621crowd_
crowdy15467171crowdy
crowns115615111crowns
crows105727311crow_s
aroids75118222aroids
becrowds1683772becrowds
broads94515152broads
broods95416382broods
browns116415632browns
brows105425982brow_s
chords125214632chords
chows135618202chow_s
clods85320862clo_ds
clouds94612352clouds
clowns114810112clowns
cods76848102c_o_ds
coeds85920162c_oeds
colds85726972c_olds
cords86030622c_ords
cowls106922212c_owls
cows97046642c_ow_s
crawls114712082crawls
craws105723122craw_s
creds85418772cr_eds
creeds94714772creeds
crews105917502crew_s
croaks125812982croaks
crocks145118422crocks
crocs95722432cro_cs
crocus104813172crocus
crofts114910592crofts
crones84729242crones
crooks124914412crooks
croons85418422croons
crops96125232cro_ps
crores86121162crores
cross75124502cro_ss
croups104312552croups
crow96428132crow__
crowded14418792crowded
crowder13389862crowder
crowders14398812crowders
crowdie1335912crowdie
crowdies1437552crowdies
crowed124717302crowed
crower114117562crower
crowers124614902crowers
crown105620082crow_n
crozes174417662crozes
cruds85815852cr_uds
droids84712582droids
drownds12346152drownds
drowns105612332drowns
fronds106412342fronds
frowns126011392frowns
frows116623102frow_s
gowds105814042_gowds
growls104711112growls
grows95523922grow_s
prods85523552pro_ds
prowls115511082prowls
prows106327012prow_s
roads66523622_roads
rods56442062_ro_ds
roods65125282_roods
rowdy125711532_rowdy
rows75941752_row_s
scrods94111612scro_ds
trows88826182trow_s
vrows116115262vrow_s

Search took 4 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 Filter178691825510.343520965.0
2DLD Change Limit82551712.68630733.8
3Display Results71710.0332151.5
 (SQL Overall)178691713.06258357.6
 
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.