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

85 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
crowns11561511(None) 
browns116415631browns
clowns114810111clowns
croons85418421croons
crowds124910761crowds
crown105620081crown_
crows105727311crow_s
drowns105612331drowns
frowns126011391frowns
brawns115614082brawns
brown105619532brown_
browny144510042browny
brows105425982brow_s
chows135618202chow_s
cions75222852cio_ns
clons75228132clo_ns
clown105214732clown_
coins75834552c_oins
conns75024232c_onns
cons66057692c_o_ns
coons76737282c_oons
corns76034762c_orns
cowls106922212c_owls
cows97046642c_ow_s
crawls114712082crawls
craws105723122craw_s
crews105917502crew_s
croaks125812982croaks
crocks145118422crocks
crocs95722432cro_cs
crocus104813172crocus
crofts114910592crofts
crone75231332cro_ne
crones84729242crones
crony105918672cro_ny
crooks124914412crooks
croon75522782croon_
crops96125242cro_ps
crores86121162crores
cross75124502cro_ss
crotons93714372crotons
croups104312552croups
crow96428132crow__
crowd115815622crow_d
crowdy15467172crowdy
crowed124717312crowed
crower114117562crower
crowers124614902crowers
crowing133814762crowing
crowned133912442crowned
crowner124012602crowner
crowners133710752crowners
crownet123714112crownet
crownets13407672crownets
crozes174417662crozes
decrowns14265062decrowns
downs94918572_downs
drown95515822drown_
drownd11478312drownd
drownds12346152drownds
frons86124042fro_ns
frown115415972frown_
frows116623102frow_s
gowns95115102_gowns
groans74815062groans
groins73917202groins
growls104711112growls
grown95317352grown_
grows95523922grow_s
irons55324132iro_ns
knowns13426442knowns
kroons103711242kroons
owns76819582__owns
prawns11509022prawns
prowls115511082prowls
prows106327012prow_s
recrowns13246142recrowns
roans54926442_roans
rowans95715342_rowans
rowens94515302_rowens
rows75941752_row_s
towns86018882_towns
trows88826182trow_s
uncrowns1344362uncrowns
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 Limit82551852.73330205.3
3Display Results85850.0302833.3
 (SQL Overall)178691853.10657530.9
 
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.