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

144 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
chined12562006(None) 
chained133812691chained
chided135113961chided
chimed145814831chimed
chine105231721chine_
chines115029171chines
chinked174011021chinked
chinned134810491chinned
coined94523601coined
shined104620781shined
whined134715201whined
alined75221402alined
brined95118412brined
cabined1239992cabined
cairned1037642cairned
caned85838092c_aned
canned95022062canned
ceiled94114952ceiled
chafed154813912chafed
chaine115119222chaine_
chaines124518732chaines
chaired134211242chaired
chanced154113212chanced
changed144214142changed
chanted134015952chanted
chared125423692chared
chased125019292chased
chawed155214602chawed
chefed155010562chefed
chewed154415012chewed
chicaned1665872chicaned
chicer134513602chicer
chid106626402chi__d
chide115321012chide_
chider125116052chider
chides124620472chides
chief134419472chi_ef
chiel104918972chi_el
chield124610212chield
child114516222chi_ld
childe124711212childe
chile105626892chile_
chiles115425302chiles
chilled133310932chilled
chime125322592chime_
chimer135517202chimer
chimes134922572chimes
chimney1795482chimney
chin96934742chin__
china105022472chin_a
chinas115119382chinas
chinch163911222chinch
chink145321592chin_k
chinks155817572chinks
chinky185610542chinky
chino105823312chin_o
chinos115018692chinos
chins105631462chin_s
chints115117832chints
chintz204212022chintz
chipped174110812chipped
chirked173810332chirked
chirmed15379732chirmed
chirped15379782chirped
chirred133612122chirred
chisel112111942chisel
chive135117622chive_
chives144317592chives
chivied16368382chivied
choired13349342choired
choked164914792choked
chored125321882chored
chowed154914642chowed
chunked17428212chunked
churned13358372churned
chuted124611842chuted
cine66242942c_ine_
cines75239682c_ines
cited84421952c_ited
cline76428532cline_
clines84926042clines
clinged113310092clinged
clinked144011642clinked
cloned94518802cloned
coifed124113062coifed
coigned11418662coigned
coiled95123932coiled
coiner84323782coiner
coned86040052c_oned
conned95119702conned
corned95224522corned
craned96121652craned
cried84624282cri_ed
cringed113312402cringed
dined76431992_dined
dwined114610212dwined
fined94930502_fined
foined105915012foined
gained84617462gained
hided105222442_hided
hied85434042_hi_ed
hiked135919202_hiked
hind85529752_hin_d
hinged114618912_hinged
hinted104318322_hinted
hired95226262_hired
hived125217912_hived
honed95332262_honed
joined144613072joined
lined64934642_lined
machined1637302machined
mined85333352_mined
opined95113852opined
pained95622852pained
peined94918842peined
phoned124014552phoned
pined85935322_pined
rained75024602rained
reined74425522reined
ruined74813322ruined
sained75424242sained
seined74023062seined
shied96125492shi_ed
shine85533092shine_
shiner93820872shiner
shines95028912shines
shinned114310912shinned
shrined114112412shrined
spined95423942spined
thine85026852thine_
thinned11399152thinned
tined65434532_tined
trined74920712trined
twined104413122twined
veined104413912veined
vined95626152_vined
whiled134514132whiled
whine116022812whine_
whiner124516632whiner
whines125120102whines
whiney155012642whiney
whinged15409142whinged
whited134814082whited
wined94434182_wined

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.1531167915.0
2DLD Change Limit825511443.01627371.0
3Display Results1441440.0463130.4
 (SQL Overall)1786911443.21555580.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.