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

304 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
chis9593331(None) 
ahis76135381ahis
chais107530311chais
chi86228651chi_
chia96026621chia
chias104625521chias
chic115925201chic
chics123920941chics
chid106626411chid
chin96934741chin
chins105631461chins
chip116726421chip
chips125721251chips
chit96937461chit
chits105424571chits
cis57748041c_is
cris66233431cris
ghis85020161ghis
his66359511_his
khis117017991khis
phis95724901phis
this76027381this
aches106132292aches
ahi68040232ahi_
ahs68644822ah_s
ais39083582_ais
amis66445322amis
anis45746472anis
aphis105917132aphis
axis116127912axis
bis56860672_bis
bris65539612bris
cabs86739422cabs
cadis84428502cadis
cads76144532cads
caid77837542caid
caids85226432caids
cain65643912cain
cains75334302cains
cams87047282cams
cans65050852cans
caps87147892caps
cars67364762cars
cats66356342cats
caws96036112caws
cays95437672cays
cedis84317082cedis
cees65941592cees
ceil65725062ceil
ceils75019402ceils
cels65534972cels
ceps86125952ceps
cess65326052cess
chad105525502chad
chads116122232chads
chai95929902chai
chain105723672chain
chains114819702chains
chair105519632chair
chairs114916182chairs
chaise114916412chaise
cham115532312cham
chams126028502chams
chao95727312chao
chaos105622862chaos
chap114928492chap
chaps125326062chaps
char95132152char
chars105936642chars
chase105127122chase
chasm125518792chasm
chat95546132chat
chats105730092chats
chaw126224632chaw
chaws135022462chaws
chay124924872chay
chays135319742chays
chef125125622chef
chefs136214662chefs
chess105016922chess
chest104926142chest
chew126622132chew
chews135418512chews
chez184519022chez
chiao105618362chiao
chiasm13449102chiasm
chiaus113611312chiaus
chica125818262chica
chicas135916472chicas
chick165419132chick
chicks175317592chicks
chico124218252chico
chicos134614832chicos
chide115321022chide
chides124620472chides
chief134419482chief
chiefs14509652chiefs
chiel104918972chiel
chiels115115932chiels
child114516222child
chile105626892chile
chiles115425302chiles
chili106218482chili
chilis115517872chilis
chill105619872chill
chills114717702chills
chimb144813562chimb
chimbs153910302chimbs
chime125322592chime
chimes134922572chimes
chimp145216472chimp
chimps155713662chimps
china105022482china
chinas115119402chinas
chine105231722chine
chines115029172chines
chink145321592chink
chinks155817572chinks
chino105823312chino
chinos115018692chinos
chints115117832chints
chirk144516182chirk
chirks155414842chirks
chirm125317062chirm
chirms135113982chirms
chiro105320342chiro
chiros114617772chiros
chirp124717162chirp
chirps135414002chirps
chirr105015902chirr
chirrs114514982chirrs
chiru105317152chiru
chirus114615692chirus
chisel112111942chisel
chive135117622chive
chives144317592chives
chivy164810362chivy
choir105313602choir
choirs114911882choirs
chon96627792chon
chop116024922chop
chops125019872chops
chose105925402chose
chow125820992chow
chows135618202chows
chrism13710672chrism
chub115516412chub
chubs125412622chubs
chug105914112chug
chugs115511942chugs
chum116318002chum
chums125015832chums
cig67036192c_ig
cigs75625112cigs
cist67244972c_ist
clip86924002clip
clips96018302clips
cobs87043142cobs
cods76848112cods
cogs77340032cogs
cohos105921852cohos
coif96337912coif
coifs105718702coifs
coil66439652coil
coils75030082coils
coin66645352coin
coins75834552coins
coir66327242coir
coirs75221052coirs
cols66553082cols
cons66057692cons
coos67456492coos
cops86751372cops
cors66656442cors
cos510270392c_os
coss66143492coss
cots68054842cots
cows97046642cows
coys97537242coys
crib86323582crib
cribs94516752cribs
cries75438402cries
crisp95014622crisp
crit65743712crit
crits75527572crits
crus65828482crus
cubs85832382cubs
cuds76730482cuds
cues65438982cues
cuif96529142cuif
cuifs104814692cuifs
cuish10313172cuish
cups85430822cups
curs65645542curs
cuss65430612cuss
cutis77723762cutis
cuts65841152cuts
cwms11439572cwms
dais57040702dais
dis46459902_dis
eches106322162eches
echos105216462echos
egis56520652egis
ghi77019882ghi_
has67372652_has
hes66654202_hes
hi57947592_hi_
hic86540572_hic
hid76248392_hid
hie67652712_hie
hies74842842_hies
him86247672_him
hims95230982_hims
hin67559572_hin
hins76448002_hins
hip86750442_hip
hips96433712_hips
hisn79620942_hisn
hiss75629222_hiss
hist76551552_hist
hit66569202_hit
hits75545142_hits
hos68364192_hos
ibis66519582ibis
ichs96214712ich_s
iris45732552iris
is27048222__is
iwis77117012iwis
khi106318312khi_
kis78051492_kis
kois85129412kois
kris86423612kris
leis45739602leis
lichis115212592lichis
lis37162282_lis
mhos95517772mhos
mis58162632_mis
obis66226842obis
ohia75719362ohia
ohias84415572ohias
ohms95514032ohms
ohs66232312oh_s
orchis11710772orchis
phi86524202phi_
phiz186718842phiz
pis56362042_pis
pois66539042pois
psis68120342psis
qis126934392_qis
rachis114017652rachis
rais45252622rais
reis45343232reis
rhos76319062rhos
rhus75114052rhus
schism1338172schism
schist11312652schist
seis45542392seis
shes75734352shes
shies86136552shies
shim95827862shim
shims104422552shims
shin75634312shin
shins85131042shins
ship95228242ship
ships105123772ships
shist84829612shist
shit76745942shit
shits84731172shits
shiv105721172shiv
shivs115018802shivs
shris84221452shris
sis37360552_sis
skis84825302skis
sris45434152sris
thin76732392thin
thins85826332thins
thio77225412thio
thir76420542thir
thus76721472thus
tis37056652_tis
tuis44829642tuis
vis66747622_vis
whid115418882whid
whids125413992whids
whig115516422whig
whigs125612642whigs
whim126220532whim
whims134515332whims
whin105225692whin
whins114922332whins
whip125521842whip
whips134917082whips
whir105519282whir
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
whit104834172whit
whits115923822whits
whiz195919942whiz
whys137011662whys
wis66552342_wis
xis106935342_xis
ywis105313102ywis

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298723040.86034734.9
3Display Results3043040.0764000.0
 (SQL Overall)1786913041.216146949.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.