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

213 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
chi8622865(None) 
ahi68040231ahi
chai95929901chai
chia96026621chia
chic115925201chic
chid106626401chid
chin96934741chin
chip116726421chip
chis95933311chis
chit96937461chit
ghi77019881ghi
hi57947581_hi
khi106318301khi
phi86524201phi
ache96829822ache
achy126316092achy
ah513868792ah_
aha611246642aha
ahis76135382ahis
ahs68644822ahs
ai211288392_ai
ami56646812ami
ani37751182ani
bi48046472_bi
cab78355402cab
cad67456362cad
cadi75732182cadi
caid77837532caid
cain65643912cain
cam78058982cam
can57760142can
cap76758982cap
car59165562car
cat58282342cat
caw86647932caw
cay87155982cay
cedi74919272cedi
cee55952702cee
ceil65725062ceil
cel56040552cel
cep75736332cep
chad105525502chad
chain105723672chain
chair105519632chair
chais107530312chais
cham115532312cham
chao95727312chao
chap114928492chap
char95132152char
chat95546132chat
chaw126224632chaw
chay124924872chay
chef125125622chef
chew126622132chew
chez184519022chez
chiao105618362chiao
chias104625522chias
chica125818262chica
chick165419132chick
chico124218252chico
chics123920942chics
chide115321012chide
chief134419482chief
chiel104918972chiel
child114516222child
chile105626892chile
chili106218482chili
chill105619872chill
chimb144813562chimb
chime125322592chime
chimp145216472chimp
china105022482china
chine105231722chine
chink145321592chink
chino105823312chino
chins105631462chins
chips125721252chips
chirk144516182chirk
chirm125317062chirm
chiro105320342chiro
chirp124717162chirp
chirr105015902chirr
chiru105317152chiru
chits105424572chits
chive135117622chive
chivy164810362chivy
choir105313602choir
chon96627792chon
chop116024922chop
chow125820992chow
chub115516412chub
chug105914112chug
chum116318002chum
cig67036182cig
cis57748032cis
clip86924002clip
cob710258752cob
cod69660122cod
cog69552902cog
coho97524492coho
coif96337912coif
coil66439652coil
coin66645352coin
coir66327242coir
col59360352col
con510268022con
coni65534802coni
coo59566362coo
cop711162372cop
cor59960942cor
cos510270392cos
cot510483222cot
cow89856712cow
cox1210346782cox
coy810557552coy
coz149345362coz
crib86323582crib
cris66233432cris
crit65743712crit
cru57129562cru
cry89726242cry
cub76940942cub
cud67937452cud
cue57544182cue
cuif96529142cuif
cum76440162cum
cup76738242cup
cur56841982cur
cut57957662cut
cwm106815082cwm
dui46433382dui
eche97520282eche
echo96615952echo
echt95722902echt
eh58339962eh_
elhi7612402elhi
ghis85020162ghis
ha510259942_ha
he58151952_he
hic86540562_hic
hid76248382_hid
hie67652702_hie
him86247662_him
hin67559562_hin
hip86750432_hip
his66359502_his
hit66569192_hit
hm78126732_hm
ho510258272_ho
ich86227742ich_
ichs96214712ichs
khis117017982khis
ki67537962_ki
koi77534752koi
lei36846382lei
li29948752_li
lichi104412952lichi
mho86624622mho
mi48249052_mi
obi57127732obi
oh57447002oh_
ohia75719362ohia
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482_oi
phis95724902phis
phiz186718842phiz
pht86030522pht
pi48145362_pi
poi57244662poi
psi56621622psi
qi116526902_qi
rai37658222rai
rei35647252rei
rho65924832rho
sei36048932sei
sh56828522sh_
sha69837782sha
she66837692she
shh97121072shh
shim95827862shim
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
shri76021702shri
shy96728192shy
si29149572_si
ski74925692ski
sri35634002sri
the67436052the
thin76732392thin
thio77225412thio
thir76420542thir
this76027382this
tho67433962tho
thy97022912thy
ti28448292_ti
tui37034022tui
uh57429852uh_
wha96422072wha
whid115418872whid
whig115516422whig
whim126220532whim
whin105225692whin
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
who95526772who
why126920012why
xi98128162_xi

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 Filter178691140840.250714764.0
2DLD Change Limit140842130.37337758.7
3Display Results2132130.0504260.0
 (SQL Overall)1786912130.673265514.1
 
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.