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

161 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
chic11592520(None) 
chi86228651chi_
chia96026621chia
chica125818261chica
chick165419131chick
chico124218251chico
chics123920941chics
chid106626401chid
chin96934741chin
chip116726421chip
chis95933311chis
chit96937461chit
hic86540561_hic
acmic11312332acmic
ahi68040232ahi_
ahis76135382ahis
caid77837532caid
cain65643912cain
ceil65725062ceil
ceric94023092ceric
chad105525502chad
chai95929902chai
chain105723672chain
chair105519632chair
chais107530312chais
cham115532312cham
chao95727312chao
chap114928492chap
char95132152char
chat95546132chat
chaw126224632chaw
chay124924872chay
check164714712check
chef125125622chef
chemic153012092chemic
chew126622132chew
chez184519022chez
chiao105618362chiao
chias104625522chias
chicas135916472chicas
chicer134513602chicer
chichi1637092chichi
chicks175317592chicks
chicle134312542chicle
chicly16429202chicly
chicos134614832chicos
chide115321012chide
chief134419482chief
chiel104918972chiel
child114516222child
chile105626892chile
chili106218482chili
chill105619872chill
chimb144813562chimb
chime125322592chime
chimp145216472chimp
china105022482china
chinch163911232chinch
chine105231722chine
chink145321592chink
chino105823312chino
chins105631462chins
chips125721252chips
chirk144516182chirk
chirm125317062chirm
chiro105320342chiro
chirp124717162chirp
chirr105015902chirr
chiru105317152chiru
chits105424572chits
chive135117622chive
chivy164810362chivy
chock164316612chock
choice132010522choice
choir105313602choir
chon96627792chon
chop116024922chop
choric133515902choric
chow125820992chow
chub115516412chub
chuck164814872chuck
chug105914112chug
chum116318002chum
chymic18317882chymic
cig67036182c_ig
cis57748032c_is
civic123412542civic
click135217952click
clip86924002clip
coif96337912coif
coil66439652coil
coin66645352coin
coir66327242coir
colic95726172colic
comic114721812comic
conic95329792conic
crib86323582crib
crick135118752crick
cris66233432cris
crit65743712crit
croc85723732croc
cubic114313422cubic
cuif96529142cuif
cynic124712422cynic
echoic1339042echoic
emic86422752emic
epic86921302epic
ethic101511222ethic
etic66123952etic
flic96223732flic
ghi77019882ghi_
ghis85020162ghis
hi57947582_hi_
hick135530302_hick
hid76248382_hid
hie67652702_hie
him86247662_him
hin67559562_hin
hip86750432_hip
his66359502_his
hit66569192_hit
huic94818052huic
ictic9311802ictic
khi106318302khi_
khis117017982khis
laic65931562laic
mic77647642_mic
odic74920572odic
ohia75719362ohia
ohmic1237832ohmic
otic66624822otic
phi86524202phi_
phis95724902phis
phiz186718842phiz
pic76046822_pic
pyic116915822pyic
shim95827862shim
shin75634312shin
ship95228242ship
shit76745942shit
shiv105721172shiv
sic55847872_sic
spic85227432spic
thick145613352thick
thin76732392thin
thio77225412thio
thir76420542thir
this76027382this
tic56343462_tic
unchic1338642unchic
uric63624942uric
which163910082which
whid115418872whid
whig115516422whig
whim126220532whim
whin105225692whin
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
zoic152316072zoic

Search took 7 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 Filter178691298721.373130146.4
2DLD Change Limit298721614.0937298.3
3Display Results1611610.0802012.5
 (SQL Overall)1786911615.54632219.8
 
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.