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

239 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
chin9693474(None) 
cain65643911cain
chain105723671chain
chi86228651chi_
chia96026621chia
chic115925201chic
chid106626401chid
china105022471china
chine105231721chine
chink145321591chink
chino105823311chino
chins105631461chins
chip116726421chip
chis95933311chis
chit96937461chit
chon96627791chon
coin66645351coin
hin67559561_hin
shin75634301shin
thin76732381thin
whin105225691whin
aching126521972aching
actin74922552actin
agin56132712agin
ahi68040232ahi_
ahing98928342ahing
ahis76135382ahis
ain37579092_ain
akin86328032akin
amin66042242amin
ayin76331742ayin
bin56658632_bin
blin67228172blin
brin67038192brin
cabin94820932cabin
caid77837532caid
cains75334302cains
cairn75717512cairn
can57760132c_an
carn66245432carn
ceil65725062ceil
chad105525502chad
chai95929902chai
chaine115119222chaine
chains114819702chains
chair105519632chair
chais107530312chais
cham115532312cham
chang115418562chang
chant105932692chant
chao95727312chao
chap114928492chap
char95132152char
chat95546132chat
chaw126224632chaw
chay124924872chay
chef125125622chef
chew126622132chew
chez184519022chez
chiao105618362chiao
chias104625512chias
chica125818262chica
chick165419132chick
chico124218252chico
chics123920942chics
chide115321012chide
chief134419472chief
chiel104918972chiel
child114516222child
chile105626892chile
chili106218482chili
chill105619872chill
chimb144813562chimb
chime125322592chime
chimp145216472chimp
chinas115119382chinas
chinch163911222chinch
chined125620062chined
chines115029172chines
chinks155817572chinks
chinky185610542chinky
chinos115018692chinos
chints115117832chints
chintz204212022chintz
chips125721252chips
chirk144516182chirk
chirm125317062chirm
chiro105320342chiro
chirp124717162chirp
chirr105015902chirr
chiru105317152chiru
chitin113114952chitin
chiton112612392chiton
chits105424572chits
chive135117622chive
chivy164810362chivy
choir105313592choir
chop116024922chop
chopin132712182chopin
chow125820992chow
chub115516412chub
chug105914112chug
chum116318002chum
chunk144812382chunk
churn105113102churn
cig67036182c_ig
cine66242942c_ine
cion613330912cion
cis57748032c_is
clan65633922clan
cline76428532cline
cling86424672cling
clink115320042clink
clip86924002clip
clon66232482clon
cochin131313192cochin
coif96337902coif
coign85013912coign
coil66439652coil
coins75834552coins
coir66327242coir
colin76231692colin
con510268022c_on
coni65534802coni
conin76232722conin
conn66229132conn
coon67248942coon
corn69945812corn
covin105621122covin
crib86323572crib
cris66233432cris
crit65743712crit
cuif96529132cuif
cuing85420192cuing
cumin94616972cumin
curn66731882curn
cutin75022772cutin
cyan96419622cyan
din46459462_din
djin12911632djin
eching126315562eching
echini114710432echini
fain75840562fain
fin66458032_fin
foin77231562foin
gain56042162gain
ghi77019882ghi_
ghis85020162ghis
gin46055752_gin
grin55733722grin
hen67555272_hen
hi57947582_hi_
hic86540562_hic
hid76248362_hid
hie67652702_hie
him86247652_him
hind85529752_hind
hins76447992_hins
hint77455742_hint
hip86750432_hip
his66359502_his
hisn79620932_hisn
hit66569192_hit
hon67759382_hon
hun65844712_hun
in28150862__in
jin106443932_jin
join116724832join
kain85334292kain
khan115819142khan
khi106318302khi_
khis117017982khis
kin76353962_kin
lain46146282lain
lin37967372_lin
loin46838722loin
main65345502main
ohia75719362ohia
ohing96018802ohing
pain65647242pain
pein65834942pein
phi86524202phi_
phis95724902phis
phiz186718842phiz
phon95925382phon
pin57066722_pin
pyin96823232pyin
quin135823922quin
rain46251732rain
rein46040892rein
rhino84614322rhino
rin36663182_rin
ruin47430512ruin
sain45551292sain
shim95827842shim
shine85533092shine
shins85131042shins
shiny115122142shiny
ship95228232ship
shit76745932shit
shiv105721162shiv
shun75122772shun
sin36265892_sin
skin85927522skin
spin66231302spin
tain45548072tain
than76128772than
thein85919022thein
then78429692then
thine85026852thine
thing96622962thing
think125018792think
thins85826322thins
thio77225412thio
thir76420542thir
this76027382this
tin36362172_tin
twin76023082twin
tyin76424002tyin
urchin1138742urchin
vain75233002vain
vein75625752vein
wain75840192wain
when105723042when
whid115418872whid
whig115516422whig
whim126220522whim
whine116022812whine
whins114922332whins
whiny144915572whiny
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
win66456292_win
yin67648732_yin
zechin20137702zechin
zein135620602zein
zin125643772_zin

Search took 1 second 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 Filter178691298720.0802233637.5
2DLD Change Limit298722390.82636164.6
3Display Results2392390.0465195.7
 (SQL Overall)1786912390.952187700.6
 
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.