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 “citterns” with Change Limit: [1] [2] [3]

(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
citterns1031812(None) 
bitterns10428951bitterns
cisterns10369581cisterns
citherns13338871citherns
cittern9339141cittern_
gitterns9326571gitterns
bittern94810682bittern_
bitters94920362bitter_s
chitters133711172chitter_s
cistern93310702cistern_
cisterna10376372cisterna
citers85022982ci_ter_s
cithern12489912cithern_
cithers124315772cither_s
cithrens13355932cithrens
cotters94323452cotter_s
critters103511332critter_s
cutters94218962cutter_s
fitters104517752fitter_s
gittern8337502gittern_
hitters104717592hitter_s
interns73116772_interns
jitters144314472jitter_s
kittens11347582kitte_ns
litters73422572litter_s
mittens9349882mitte_ns
patterns10439942patterns
ritters74020622ritter_s
sitters74221552sitter_s
titters74219622titter_s
zitherns20376132zitherns
attorns738443_attorns
battens95313263batte_ns
batters94626023batter_s
betters94422093better_s
bisters93922613bister_s
biters83925243bi_ter_s
bitten84715123bitte_n_
bitter84622673bitter__
bittered112711833bittered
bitterer10309783bitterer
bitterest1147713bitterest
bittering122512003bittering
bitterish1446143bitterish
bitterly1335603bitterly
bitterness1245553bitterness
bitternut1144333bitternut
bitternuts1242733bitternuts
butters94521723butter_s
canteens1038573canteens
canters94827733canter_s
carters95327253carter_s
caserns94711223c_aserns
casters94729903caster_s
caterans10313223c_aterans
caters85336503c_ater_s
catteries11815543catteries
cattery123811603catter_y
caverns124510253c_averns
centers94420603center_s
chatters134213953chatter_s
chitter124112963chitter__
chittered15166413chittered
chittering16107183chittering
ciceros1158593ci_ceros
ciders94620093ci_der_s
cinders104617763cinder_s
cinerins10414103ci_nerins
ciphers14379993cipher_s
cisternae11265093cisternae
cisternal11325743cisternal
cistrons102710643cistrons
citations11312503citations
citators10310253citator_s
citer74827333ci_ter__
cites74435593ci_te__s
citharas13156723citharas
cither114616683cither__
cithren12306593cithren_
cities84524853citie__s
citizens1943983citizens
citreous1056853citreous
citrins92614363ci_trins
citrons92913223ci_trons
citrus83610923ci_t_rus
clatters103313913clatter_s
clutters103210353clutter_s
coaters93525793coater_s
cointers103616423cointer_s
colters93522443colter_s
concerns122710833concerns
contemns1237403contemns
cooters94525733cooter_s
copters113621283copter_s
costers94128343coster_s
cothurns1344523cothurns
cottars94412243cottar_s
cotter84926673cotter__
cottered112511743cottered
cottiers10399163cottier_s
cottons9312193cott_ons
couters93827303couter_s
craters95021893crater_s
critter94113033critter__
critturs10374593crittur_s
cutlers94217003cutler_s
cutter84521003cutter__
cysteins1355733cysteins
dieters83216433dieter_s
dipterans1245723dipterans
discerns1138163discerns
dithers114016153dither_s
dotters83715973dotter_s
emitters10349643emitter_s
externs1438233_externs
fattens105111713fatte_ns
fetters103517903fetter_s
fifteens1442753fifteens
filters103816553filter_s
fitter94120033fitter__
flitters114312173flitter_s
fritters113810783fritter_s
getters84216103getter_s
glitters93710543glitter_s
gritters94210633gritter_s
gutters83715513gutter_s
hatters104221523hatter_s
hinters103719583hinter_s
hitter94419863hitter__
icterus936083_icterus
intern64016543_intern_
interne73218153_interne
internes82721233_internes
inters64328053_inter_s
inturns73210133_inturns
jilters144211963jilter_s
jitter133314993jitter__
jittered16267223jittered
jittering17218423jittering
jittery17346443jitter_y
jotters143413803jotter_s
kilters113813603kilter_s
kiters105218593ki_ter_s
kitten104611483kitte_n_
knitters12336623knitter_s
lanterns838303lanterns
lattens75014673latte_ns
lecterns1035943lecterns
letters73819853letter_s
lifters104313783lifter_s
linters73822633linter_s
listens74014133liste_ns
listers74026533lister_s
liters65429883li_ter_s
litten64014873litte_n_
litter64324853litter__
littered92511383littered
litterer82810173litterer
litterers9228193litterers
littering102411983littering
littery103710493litter_y
lotters73921063lotter_s
lutherns1136293lutherns
matters94421753matter_s
midterms13284863midterms
milters93619093milter_s
minters93822473minter_s
misterms123711353misterms
misters93927513mister_s
miters84328783mi_ter_s
mithers123516733mither_s
mitten83914093mitte_n_
mutters94117143mutter_s
natters73718063natter_s
netters73618583netter_s
niters64624213ni_ter_s
nutters74215433nutter_s
omitters10277653omitter_s
otters64021513_otter_s
outturns835913outturns
pasterns104112623pasterns
pattens95414923patte_ns
pattern93712053pattern_
patters94825193patter_s
petters93722363petter_s
pitiers93812653pitier_s
posterns102713723posterns
potteens10256793potteens
potters94024343potter_s
putters94219193putter_s
quitters17238523quitter_s
ratteens8256053ratteens
rattens74213403ratte_ns
ratters74422473ratter_s
rioters73615523rioter_s
ritter63822423ritter__
rotters74421393rotter_s
salterns8388903salterns
scatters103612753scatter_s
scutters103311023scutter_s
setters73822063setter_s
sifters103714793sifter_s
sinters74024083sinter_s
sisters73721593sister_s
sithens1039383sithe_ns
sitten64113823sitte_n_
sitter63323383sitter__
sixteens1542943sixteens
skitters12349553skitter_s
slatterns935363slatterns
slitters84014133slitter_s
spitters104113383spitter_s
sterns64616763__sterns
tatters74520483tatter_s
terns55226873___terns
tetters74320473tetter_s
tilters73315953tilter_s
tinters74221113tinter_s
titers64526413ti_ter_s
titfers10318933titfer_s
tithers104216733tither_s
titter63421163titter__
tittered9239493tittered
titterer8268523titterer
titterers9236993titterers
tittering102310313tittering
totters74618733totter_s
twitters11296773twitter_s
utters63817123_utter_s
vetters104016323vetter_s
westerns11328963westerns
wetters103817753wetter_s
whitters14359403whitter_s
winters103720483winter_s
withers134417753wither_s
wiverns13366963wi_verns
yatters103914623yatter_s
zithern19447023zithern_
zithers193911973zither_s

Search took 9 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 Filter1786911461620.470380193.6
2DLD Change Limit1461622397.50019488.3
3Display Results2392390.0932569.9
 (SQL Overall)1786912398.06322161.9
 
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.