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

119 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
croon7552278(None) 
coon67248941c_oon
crook115217571crook
croons85418421croons
croton84415451croton
crown105620081crown
kroon94514481kroon
aboon74918702aboon
argon65520592argon
arson55118832arson
boon67142172_boon
boron76727142boron
broo65129822broo_
brood84620242brood
brook114717762brook
broom95022212broom
broos75126412broos
brown105619532brown
cajon144513902cajon
canon74725302canon
capon95221872capon
carbon104919042carbon
cardon94120852cardon
cardoon104813812cardoon
carton84522662carton
cartoon94114462cartoon
chon96627792c_hon
chook146015042chook
chronon1237352chronon
cion613330912c_ion
clon66232482c_lon
cloot76127052cloot
clown105214732clown
cocoon10312262cocoon
codon86522852codon
cogon89120902cogon
coin66645352c_oin
colon78630192colon
con510268022c__on
conn66229132c_onn
coo59566362c_oo_
coof96643272c_oof
cook107236932c_ook
cool66940492c_ool
coons76737282c_oons
coop87238652c_oop
coos67456492c_oos
coot67860382c_oot
cordon95017292cordon
corn69945812c_orn
corona83817402corona
craton84517192craton
crayon114110002crayon
crepon1039942crepon
croak115216632croak
croc85723732cr_oc
croci95818132croci
crock135921992crock
crocs95722432crocs
croft105622682croft
crone75231332crone
crony105918672crony
crooks124914412crooks
crooned103813352crooned
crooner93714042crooner
crop87628632cr_op
crops96125242crops
crore74922872crore
cross75124502cross
crotons93714372crotons
croup95616782croup
crouton947132crouton
crow96428132cr_ow
crowd115815622crowd
crowns115615112crowns
crows105727312crows
croze164719452croze
cruor7310452cruor
cyton101511462cyton
dromon939362dromon
drool65416102drool
droop85814822droop
drown95515822drown
frown115415972frown
goon57236172_goon
groan65618422groan
groin65521082groin
groom85317982groom
grown95317352grown
iron46728462ir_on
krooni10397182krooni
kroons103711242kroons
loon47344792_loon
maroon83118202maroon
moon67140812_moon
moron76925422moron
noon47134622_noon
orlon5415002orlon
poon67341262_poon
prion75119992prion
proof105221532proof
proton84318892proton
roan47234202_roan
rood56733002_rood
roof75738832_roof
rook85532032_rook
room66235082_room
root45655922_root
scroop10299782scroop
shoon84022012shoon
soon46240502_soon
spoon74719442spoon
swoon85014782swoon
toon47740632_toon
trogon73611752trogon
troop76417532troop
trooz145016152trooz
vroom105312472vroom
zoon137326982_zoon

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 Filter178691538000.313570897.8
2DLD Change Limit538001191.65632487.9
3Display Results1191190.0303966.7
 (SQL Overall)1786911191.99989390.2
 
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.