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

282 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
citer7482733(None) 
biter75030031biter
cater74840721cater
cider84723321cider
cite65640351cite_
cited84421951cited
citers85022981citers
cites74435591cites
cither114616681cither
cuter74728231cuter
kiter95523221kiter
liter54736341liter
miter75734791miter
niter55028971niter
titer55430611titer
acuter84412862acuter
after85719792after
aider65431142aider
aimer75926822aimer
airer54927892airer
aiver85725162aiver
alter54828502alter
apter76120202apter
aster55434892aster
baiter84422562baiter
bider85728382bider
bier65531842bi_er
biker116022562biker
biner75930692biner
bister84922762bister
bite66547012bite_
biters83925242biters
bites75641172bites
bitter84622672bitter
caber95126832caber
cager85229222cager
caner75334772caner
canter85230112canter
caper94831622caper
carer74942332carer
carter84932272carter
caster85232572caster
cate66254602cate_
caters85336502caters
cates75951892cates
caver105629062caver
ceder85322242ceder
ceiler84013962ceiler
center84421412center
cete64934782cete_
cetes75731102cetes
cheer105420382cheer
chicer134513602chicer
chider125116052chider
chimer135517202chimer
chitter124112962chitter
cicero1048502cicero
ciders94620092ciders
cigar8911802cigar
cimex16119132cimex
cinder94119122cinder
cine66242952cine_
cines75239682cines
cipher133710262cipher
cire65836382cire_
cires74932912cires
cisted95217522cisted
cistern93310702cistern
cithern12489912cithern
cithers124315772cithers
citied94014142citied
cities84524852cities
cittern9339142cittern
city95122632cit_y
civet105828732civet
coater84329572coater
coder86134222coder
coiler84421592coiler
coiner84323782coiner
cointer93616722cointer
colter84625092colter
comer95832692comer
cooer74831012cooer
cooter85128612cooter
coper95336092coper
copter109822012copter
corer75538872corer
coster84331292coster
cote66648732cote_
coted85033852coted
cotes76347842cotes
cotter84926672cotter
couter84930222couter
cover105430772cover
cower104531772cower
coyer105222842coyer
crater85026642crater
crier74724462crier
critter94113032critter
cuber95222532cuber
curer75030752curer
curter85320082curter
cute66440452cute_
cutes79438322cutes
cutey105819792cutey
cutler84718032cutler
cutter84521002cutter
cyber124910382cyber
cyder114611132cyder
dater65332312dater
deter65028042deter
dicer85426422dicer
dieter73516772dieter
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
dite55547562dite_
dites66339152dites
dither104417682dither
diver94827802diver
doter65428622doter
eater54639842eater
eider64624752eider
either94517422either
enter54726382enter
ester54727712ester
exciter1637752exciter
fiber104921132fiber
fifer115519972fifer
filer85433002filer
filter94517632filter
finer85431562finer
firer811229252firer
fitter94120032fitter
fiver116024942fiver
fixer154717832fixer
gaiter73819502gaiter
gater64533652gater
giber85417702giber
gite55438622gite_
gites65630182gites
giver94921202giver
goiter74116202goiter
hater85034752hater
hider95024092hider
hiker125119392hiker
hinter94021302hinter
hirer85423122hirer
hither124417252hither
hitter94419862hitter
icier74313752icier
icker114018442icker
inciter93113772inciter
inter55028492inter
item65620382_item
ither84617602_ither
jiber145115702jiber
jilter133512512jilter
jitter133314992jitter
jiver155119052jiver
kier86526822ki_er
kilter103714342kilter
kite85338252kite_
kited105120102kited
kiters105218592kiters
kites95432552kites
later54843922later
liber74723622liber
lier45942472li_er
lifer85822152lifer
lifter93814812lifter
liger65024472liger
liker95627062liker
liner55938922liner
linter64625342linter
lister64527252lister
lite47054552lite_
liters65429882liters
lither94520952lither
litre55421462litre
litter64324852litter
liver85132962liver
loiter64619172loiter
mater74438862mater
meter75130322meter
miler75733062miler
milter84921232milter
mimer94825762mimer
miner76933542miner
minter84425102minter
miser75430402miser
mister84728562mister
mite66249422mite_
miters84328782miters
mites75141802mites
mither114218562mither
mitier83620672mitier
mitre75522422mitre
mixer145017642mixer
muter74525542muter
nicer74618292nicer
nite45943592nite_
niters64624212niters
nitery94412172nitery
nites55736342nites
nitre57519682nitre
noter55025642noter
oater55433732oater
ofter84116872ofter
oiler54628282oiler
otter54423972otter
outer55633302outer
oxter123414092oxter
pater74740732pater
peter74427592peter
pier66035302pi_er
piker115622842piker
piper96523192piper
pitier84019822pitier
rater54943282rater
reciter94117262reciter
ricer74726612ricer
rider65231312rider
rifer84721982rifer
rimer75429242rimer
rioter64817282rioter
riper74328402riper
riser55431052riser
rite45849462rite_
rites54442552rites
ritter63822422ritter
river85731692river
scoter83815482scoter
sifter94516232sifter
siker95326032siker
sinter63625922sinter
sister64421582sister
sitar54820542sitar
site47052422site_
sited65130742sited
sites56045432sites
sitter63323382sitter
siver85728612siver
sizer145521812sizer
smiter83616412smiter
suiter64121812suiter
tater54138612tater
tier44936152ti_er
tiger65718632tiger
tiler56131022tiler
tilter63417692tilter
timer75626042timer
tinter63923642tinter
titers64526412titers
titfer9409522titfer
tither94920282tither
titre54619392titre
titter63421162titter
toter55932132toter
triter65120592triter
uniter64619142uniter
utter54218762utter
vier75428162vi_er
viler86324162viler
viper105017302viper
voter85121052voter
waiter94321252waiter
water84733322water
whiter124316392whiter
wider94826362wider
winter94222802winter
wiper105421292wiper
wirer85124952wirer
wiser85522802wiser
wite75443282wite_
wited94727142wited
wites85536962wites
wither124321352wither
wiver115924512wiver
writer94416512writer
zither183813082zither

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit538002821.72031279.1
3Display Results2822820.0763710.5
 (SQL Overall)1786912822.12684050.3
 
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.