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

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

111 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
croons8541842(None) 
coons76737281c_oons
crooks124914411crooks
croon75522781croon_
crotons93714371crotons
crowns115615111crowns
kroons103711241kroons
argons75018202argons
arsons63917212arsons
boons75031912_boons
borons85520542borons
broods95416382broods
brooks125813882brooks
brooms104915872brooms
broos75126412broo_s
browns116415632browns
canons85522062canons
capons104119502capons
carbons115418942carbons
cardons104519942cardons
cardoons113411942cardoons
cartons94122472cartons
cartoons104012802cartoons
chooks155312792chooks
chronons1347352chronons
cions75222852c_ions
clons75228132c_lons
cloots85113692cloots
clowns114810112clowns
cocoons11310562cocoons
codons96119462codons
cogons96818112cogons
coins75834552c_oins
colons86028682colons
conns75024232c_onns
cons66057692c__ons
coofs105924712c_oofs
cooks115429142c_ooks
cools75632632c_ools
coon67248942c_oon_
coops96229642c_oops
coos67456492c_oo_s
coots75636842c_oots
cordons104415762cordons
corns76034762c_orns
corona83817402corona
coronas93916912coronas
cratons94316032cratons
crayons12439232crayons
crepons1139322crepons
croaks125812982croaks
crocks145118422crocks
crocs95722432cr_ocs
crocus104813172crocus
crofts114910592crofts
crone75231332cr_one
crones84729242crones
crony105918672cr_ony
crook115217572croo_k
crooned103813342crooned
crooner93714042crooner
crooners103911392crooners
crops96125232cr_ops
crores86121162crores
cross75124502cr_oss
croton84415452croton_
croups104312552croups
croutons1036752croutons
crowds124910762crowds
crown105620082crown_
crows105727312cr_ows
crozes174417662crozes
cruors838642cruors
cytons111710182cytons
dromons1038192dromons
drools74412812drools
droops95110962droops
drowns105612332drowns
frons86124042fr_ons
frowns126011392frowns
goons65326772_goons
groans74815062groans
groins73917202groins
grooms94512522grooms
irons55324132ir_ons
kroon94514482kroon_
krooni10397182krooni
loons55731722_loons
maroons92615552maroons
moons75331002_moons
morons84919542morons
noons54125282_noons
orlons6411012orlons
poons75430972_poons
prions84317782prions
proofs114511682proofs
protons93118002protons
roans54926442_roans
roods65125282_roods
roofs85321152_roofs
rooks95325042_rooks
rooms75324682_rooms
roots55933672_roots
scroops11288252scroops
spoons84116022spoons
swoons94511142swoons
toons55027532_toons
trogons83410722trogons
troops85712782troops
vrooms11398712vrooms
zoons144919692_zoons

Search took 3 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.346516448.0
2DLD Change Limit825511112.51332849.6
3Display Results1111110.0462413.0
 (SQL Overall)1786911112.90561511.5
 
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.