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

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

155 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
chidden1425522(None) 
hidden11429741_hidden
bidden104010792_bidden
chicken18278982chicken
chide115321012chi_de_
chided135113962chi_ded
chider125116052chi_der
chides124620472chi_des
childe124711212childe_
childes134211272childes
children1474702children
chirren12388742chirren
chudder14245942chudder
hodden113811452_hodden
midden104112852_midden
ridden83511722_ridden
shodden12265762shodden
slidden935152slidden
swidden1234232swidden
whidded1634422whidded
aidmen92610373_aidmen
bidder104114863_bidder
chainmen15105263chainmen
chairmen15105473chairmen
chapmen1637283chapmen
chasten124312403chasten
chazzen20214783chazzen
cheapen14407623cheapen
cheddar14254733cheddar
cheder125113493ch_eder
chicane1489553chicane
chicer134513603chi_cer
chickee183111553chickee
chickens19267433chickens
chicle134312543chicle_
chicles143512503chicles
chid106626403chi_d__
chiders135312943chiders
chiding143911593chiding
chief134419483chi__ef
chiefer1536863chiefer
chiel104918973chi__el
chiffon1844053chiffon
chigger1436003chigger
chignon1344623chignon
chigoe1237533chigoe_
chigoes1338353chigoes
child114516223child__
childbed1742883childbed
childing15288503childing
childly1644803childly
chile105626893chi_le_
chiles115425303chi_les
chilies124218303chilies
chilled133310933chilled
chiller124112183chiller
chime125322593chi_me_
chimed145814833chi_med
chimer135517203chi_mer
chimes134922573chi_mes
chimley1785163chimley
chimney1795483chimney
chin96934743chi___n
chine105231723chi_ne_
chined125620063chi_ned
chines115029173chi_nes
chinked174011023chinked
chinned134810493chinned
chinone12510153chinone
chipped174110813chipped
chipper163912583chipper
chirked173810333chirked
chirker16429323chirker
chirmed15379733chirmed
chirped15379783chirped
chirper14359963chirper
chirre114111853chirre_
chirred133612123chirred
chirres123812253chirres
chisel112111943chi_sel
chitin113114963chi_tin
chitlin12269283chitlin
chiton112612393chi_ton
chitter124112963chitter
chive135117623chi_ve_
chives144317593chi_ves
chivied16368383chivied
chivies153412853chivies
chorded144710553chorded
chorten122811303chorten
chosen116014133ch_osen
chowder16387813chowder
christen13106703christen
chuddah17263253chuddah
chuddar14263963chuddar
chudders15235563chudders
cider84723313c_i_der
cinder94119123c_inder
cladded12356923cladded
cnidae978143cnidae_
codded114515303c_odded
codder104416343c_odder
coden86128543c__oden
crispen11348203crispen
crudded1235733crudded
gladden10376313gladden
gridded11387583gridded
gridder10367763gridder
harden105718533_harden
hiddenly1642393_hiddenly
hide85134643_hi_de_
hided105222443_hi_ded
hider95024083_hi_der
hides95129423_hi_des
hinder104120063_hinder
hitmen11239193_hitmen
hoddens12378803_hoddens
hoddin11369943_hoddin
hoiden103612333_hoiden
holden104113953_holden
hoyden13328933_hoyden
kidded13299393_kidded
kidder123811103_kidder
lidded93410243_lidded
linden7411453_linden
madden103912523_madden
maiden93512283mai_den
middens11379383_middens
milden94113153_milden
outchidden1751653outchidden
rebidden1243033rebidden
redden83613623_redden
ridded93615123_ridded
ridder84015143_ridder
sadden83212403_sadden
shedded13419063shedded
shedder12339323shedder
shipmen14317283shipmen
shippen14298863shippen
shudder12297323shudder
skidded1465083skidded
skidder1365733skidder
smidgen11426513smidgen
sodden84011513_sodden
stridden1044273stridden
sudden83310833_sudden
swiddens1342713swiddens
thicken16317873thicken
thudded1333433thudded
trodden934883trodden
unbidden1263573unbidden
whidding1734573whidding
whiten124111923whi_ten
widder112913973_widder
widen94717973_wi_den

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271556.73619897.1
3Display Results1551550.0632460.3
 (SQL Overall)1786911557.18924856.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.