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

394 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
cittern933914(None) 
bittern94810681bittern
cistern93310701cistern
cithern12489911cithern
citterns10318121citterns
gittern8337501gittern
bitten84715122bitte_n
bitter84622672bitter_
bitterns10428952bitterns
bitters94920362bitters
cattery123811602cattery
chitter124112962chitter_
chitters133711172chitters
cisterna10376362cisterna
cisterns10369572cisterns
citer74827332ci_ter_
citers85022982ci_ters
cither114616682cither_
citherns13338872citherns
cithers124315772cithers
cithren12306592cithren
cotter84926672cotter_
cotters94323442cotters
critter94113032critter_
critters103511322critters
cutter84521002cutter_
cutters94218962cutters
fitter94120032fitter_
fitters104517752fitters
gitterns9326572gitterns
hitter94419862hitter_
hitters104717592hitters
intern64016542_intern
jitter133314992jitter_
jitters144314472jitters
jittery17346442jittery
kitten104611482kitte_n
litten64014872litte_n
litter64324852litter_
litters73422572litters
littery103710492littery
mitten83914092mitte_n
pattern93712052pattern
ritter63822422ritter_
ritters74020622ritters
sitten64113822sitte_n
sitter63323382sitter_
sitters74221552sitters
titter63421162titter_
titters74219622titters
zithern19447022zithern
astern64815813_astern
attorn6310793_attorn
batten85217123batte_n
batter84928873batter_
batters94626013batters
battery124911813battery
better84723703better_
betters94422093betters
bister84922763bister_
bisters93922613bisters
biter75030033bi_ter_
biters83925243bi_ters
bitted94418483bitte_d
bittered112711833bittered
bitterer10309773bitterer
bittering122511993bittering
bitterly1335603bitterly
bitternut1144323bitternut
bittier94211663bittier_
butter84724233butter_
butters94521723butters
buttery124311193buttery
canteen9411083canteen
canter85230113canter_
canters94827733canters
carter84932273carter_
carters95327253carters
casern84713313c_asern
caster85232573caster_
casters94729903casters
cater74840723c_ater_
cateran9313773c_ateran
caters85336503c_aters
catted95422473catte_d
cattier93317073cattier_
cautery12349593cautery
cavern115312453c_avern
center84421413center_
centers94420603centers
chatter124416643chatter_
chatters134213953chatters
chattery16357273chattery
chittered15166413chittered
chittering16107183chittering
cicero1048503ci_cero
cider84723313ci_der_
ciders94620093ci_ders
cinder94119123cinder_
cinders104617763cinders
cindery13429193cindery
cinerin9313823ci_nerin
cipher133710263cipher_
ciphers14379993ciphers
cisted95217523ciste_d
cisternae11265093cisternae
cisternal11325743cisternal
cistron9299883cistron
citation10314363citation
citator9310123citator_
citators10310253citators
citatory1347213citatory
cite65640343ci_te__
cited84421953ci_te_d
cites74435593ci_te_s
cithara12166513cithara
cithrens13355933cithrens
citied94014143citie_d
cities84524853citie_s
citizen1845713citizen
citrin82615413ci_trin
citron83112983ci_tron
clatter94014973clatter_
clatters103313913clatters
clattery13378193clattery
clutter94211663clutter_
clutters103210353clutters
cluttery13346323cluttery
coater84329573coater_
coaters93525793coaters
cointer93616723cointer_
cointers103616413cointers
colter84625093colter_
colters93522443colters
concern113011963concern
contemn1137803contemn
cooter85128613cooter_
cooters94525723cooters
copter109822013copter_
copters113621283copters
coster84331293coster_
costers94128333costers
cothurn1245053cothurn
cottar84613813cottar_
cottars94412243cottars
cottered112511733cottered
cottier93814173cottier_
cottiers10399153cottiers
cotton8312993cott_on
couter84930223couter_
couters93827303couters
crater85026643crater_
craters95021893craters
crittur9315133crittur_
critturs10374593critturs
curter85320083curter_
cuter74728233c_uter_
cutler84718033cutler_
cutlers94217003cutlers
cutlery12448393cutlery
cystein1246053cystein
dieter73516773dieter_
dieters83216433dieters
diptera1037213diptera
dipteran1146203dipteran
dipteron1145593dipteron
discern1038493discern
dither104417683dither_
dithers114016153dithers
dithery14318943dithery
dotter74419343dotter_
dotters83715973dotters
eastern74412533eastern
either94517423either_
emitter93211083emitter_
emitters10349643emitters
extern1348473_extern
fatten94314903fatte_n
fatter94523213fatter_
fetter94120383fetter_
fetters103517903fetters
fifteen1343923fifteen
filter94517633filter_
filters103816553filters
fitted104716663fitte_d
fittest102510803fittest
flitter103413903flitter_
flitters114312173flitters
fritter103912773fritter_
fritters113810783fritters
getter74117613getter_
getters84216103getters
gitted84015053gitte_d
gittin72910553gitt_in
glitter84211803glitter_
glitters93710543glitters
glittery12375613glittery
gotten73410113gotte_n
gritter83913353gritter_
gritters94210633gritters
gutter73817713gutter_
gutters83715513gutters
guttery11427763guttery
hatter94724873hatter_
hatters104221523hatters
hinter94021303hinter_
hinters103719583hinters
hither124417253hither_
hitmen11239193hitme_n
hotter94720083hotter_
inter55028493_inter_
interne73218143_interne
interns73116773_interns
inters64328053_inters
inturn63411563_inturn
ither84617603_ither_
jilter133512513jilter_
jilters144211963jilters
jittered16267223jittered
jittering17218423jittering
jotter134315633jotter_
jotters143413803jotters
kilter103714343kilter_
kilters113813603kilters
kiter95523213ki_ter_
kiters105218593ki_ters
kitted115114833kitte_d
kittel10368873kitte_l
kittens11347583kittens
kittler11338163kittler_
knitter11348133knitter_
knitters12336623knitters
lantern7310013lantern
latten65018203latte_n
latter65027893latter_
lectern937033lectern
letter63722583letter_
letters73819853letters
lifter93814813lifter_
lifters104313783lifters
linter64625343linter_
linters73822633linters
listen64816813liste_n
lister64527253lister_
listers74026533listers
liter54736343li_ter_
liters65429883li_ters
lither94520953lither_
littered92511383littered
litterer82810173litterer
littering102411983littering
littler7348553littler_
lotter64025603lotter_
lotters73921063lotters
lottery10389833lottery
luthern1037653luthern
matter84325343matter_
matters94421753matters
mattery123810713mattery
midterm12316013midterm
milter84921233milter_
milters93619093milters
minter84425103minter_
minters93822473minters
mister84728563mister_
misterm114314513misterm
misters93927513misters
miter75734793mi_ter_
miters84328783mi_ters
mither114218563mither_
mithers123516733mithers
mitier83620673mitier_
mittens9349883mittens
mutter84418883mutter_
mutters94117143mutters
natter64420743natter_
natters73718063natters
netter63722023netter_
netters73618583netters
niter55028973ni_ter_
niters64624213ni_ters
nitery94412173ni_tery
nittier73512243nittier_
nutter63918053nutter_
nutters74215433nutters
omitter9298503omitter_
omitters10277653omitters
otter54423973_otter_
otters64021513_otters
outturn737123outturn
pastern94415063pastern
patten84418193patte_n
patter84628263patter_
patterns10439943patterns
patters94825193patters
petter83924773petter_
petters93722363petters
pitier84019823pitier_
pitiers93812653pitiers
pitmen102510793pitme_n
pitted94319593pitte_d
postern93615613postern
potteen9319673potteen
potter83926983potter_
potters94024343potters
pottery123011073pottery
putter83921443putter_
putters94219193putters
quitter162910753quitter_
quitters17238523quitters
ratteen7329113ratteen
ratten64217383ratte_n
ratter64326313ratter_
ratters74422473ratters
rioter64817283rioter_
rioters73615513rioters
rotten64115433rotte_n
rotter64325463rotter_
rotters74421393rotters
saltern74010653saltern
scatter93815173scatter_
scatters103612753scatters
scutter93512173scutter_
scutters103311023scutters
setter64023723setter_
setters73822063setters
sifter94516233sifter_
sifters103714793sifters
silvern10347143silvern
sinter63625923sinter_
sinters74024083sinters
sister64421583sister_
sisters73721593sisters
sixteen1434113sixteen
skitter113810403skitter_
skitters12349553skitters
skittery15315103skittery
slattern837093slattern
slitter73615873slitter_
slitters84014133slitters
smitten936693smitte_n
spitter94015183spitter_
spitters104113383spitters
stern55319123__stern
tatter64024573tatter_
tatters74520483tatters
tern46134803___tern
tetter64322453tetter_
tetters74320473tetters
tilter63417693tilter_
tilters73315953tilters
tinter63923643tinter_
tinters74221113tinters
titer55430613ti_ter_
titers64526413ti_ters
titfer9409523titfer_
titfers10318933titfers
tither94920283tither_
tithers104216733tithers
titmen8239883titme_n
tittered9239493tittered
titterer8268523titterer
tittering102310313tittering
totter65021463totter_
totters74618733totters
tottery10388483tottery
twitter10278093twitter_
twitters11296773twitters
twittery14303893twittery
utter54218763_utter_
utters63817123_utters
vetter93417643vetter_
vetters104016323vetters
watter93221983watter_
western102911093western
wetter93919443wetter_
wetters103817753wetters
whitter139110893whitter_
whitters14359403whitters
winter94222803winter_
winters103720483winters
wintery13399753wintery
wither124321353wither_
withers134417753withers
witted104216813witte_d
wittier103910823wittier_
wivern12409283wi_vern
written10336343writte_n
yatter94116213yatter_
yatters103914623yatters
yestern10338633yestern
zither183813083zither_
zitherns20376133zitherns
zithers193911973zithers

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273946.11021935.7
3Display Results3943940.1402814.3
 (SQL Overall)1786913946.65626846.6
 
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.