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

422 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
cistern9331070(None) 
cisterna10376361cisterna
cisterns10369571cisterns
cittern9339141cittern
astern64815812_astern
bister84922762bister_
bisters93922612bisters
bittern94810682bittern
casern84713312cas_ern
caster85232572caster_
casters94729902casters
cisted95217522ciste_d
cisternae11265092cisternae
cisternal11325742cisternal
cistron9299882cistron
citer74827332ci_ter_
citers85022982ci_ters
cithern12489912cithern
citterns10318122citterns
coster84331292coster_
costers94128332costers
cystein1246052cystein
discern1038492discern
eastern74412532eastern
gittern8337502gittern
intern64016542_intern
listen64816812liste_n
lister64527252lister_
listers74026532listers
mister84728562mister_
misterm114314512misterm
misters93927512misters
pastern94415062pastern
postern93615612postern
sister64421582sister_
sisters73721592sisters
stern55319122__stern
western102911102western
yestern10338642yestern
aster55434893_aster_
asters65631603_asters
austere7312993austere
baster85333593baster_
basters94930303basters
bistered112913333bistered
bistort91216523bistort
bistre83815023bist_re
bistred103311853bistred
bistres94017213bistres
bistro8339943bist_ro
biter75030033bi_ter_
biters83925243bi_ters
bitten84715123bitte_n
bitter84622673bitter_
bitterns10428953bitterns
bitters94920363bitters
blister94415313blister_
blisters104015083blisters
blistery13418713blistery
buster84726493buster_
busters94724133busters
canister101710853canister_
canisters112310193canisters
canteen9411083canteen
canter85230113canter_
canters94827733canters
carter84932273carter_
carters95327253carters
casein83216453cas_ein
caserne93710063cas_erne
caserns94711223cas_erns
caste75932363caste__
castes85631863caste_s
castor84418533castor_
castors94919443castors
cater74840723c_ater_
cateran9313773c_ateran
caters85336503c_aters
cattery123811603cattery
cautery12349593cautery
cavern115312453c_avern
center84421413center_
centers94420603centers
chasten124312403chaste_n
chaster124718503chaster_
chitter124112963chitter_
chitters133711173chitters
christen13106703christe_n
cicero1048503ci_cero
cider84723313ci_der_
ciders94620093ci_ders
cinder94119123cinder_
cinders104617763cinders
cindery13429193cindery
cinerin9313823ci_nerin
cipher133710263cipher_
ciphers14379993ciphers
cist67244963cist___
cistrons102710623cistrons
cists76624533cist__s
cistus84611343cist_us
cite65640343ci_te__
cited84421953ci_te_d
cites74435593ci_te_s
cither114616683cither_
citherns13338873citherns
cithers124315773cithers
cithren12306593ci_thren
citrin82615413ci_trin
citron83112983ci_tron
cloister1037093cloister_
cloisters1137433cloisters
cluster94013333cluster_
clusters102912403clusters
clustery13317113clustery
clyster12317453clyster_
clysters13227843clysters
coaster94219043coaster_
coasters104317333coasters
coater84329573coater_
coaters93525793coaters
cointer93616723cointer_
cointers103616413cointers
coistrel1046743coistrel
colter84625093colter_
colters93522443colters
concern113011963concern
contemn1137803contemn
cooter85128613cooter_
cooters94525723cooters
copter109822013copter_
copters113621283copters
cosher114819903cosher_
coshers123618183coshers
cosier84423753cosier_
costar85518613costar_
costard104113353costard
costars94218013costars
costed95623113coste_d
costrel9310373costrel
cotter84926673cotter_
cotters94323443cotters
couter84930223couter_
couters93827303couters
crater85026643crater_
craters95021893craters
crispen11348203crispe_n
crisper113511053crisper_
crispers12309433crispers
critter94113033critter_
critters103511323critters
curter85320083curter_
cusser86016093cusser_
cussers94213403cussers
custard10389973custard
cuter74728233c_uter_
cutter84521003cutter_
cutters94218963cutters
cysteine1345333cysteine
cysteins1355733cysteins
diaster82813313diaster_
diasters92913183diasters
diester83013683diester_
diesters92513603diesters
dieter73516773dieter_
dieters83216433dieters
diptera1037213diptera
dipteran1146203dipteran
dipteron1145593dipteron
discerns1138163discerns
dissert83720693dissert
distain8313783distain
distend93312073distend
distent84120853distent
distort81120333distort
disturb1046233disturb
duster74919723duster_
dusters84918363dusters
easter65027983easter_
easters75125683easters
einstein844183einstein
eiswein1043503eiswein
episterna1143373episterna
ester54727713_ester_
esters64627733_esters
extern1348473_extern
fasten95114893faste_n
faster94625773faster_
fester94723513fester_
festers104121393festers
fibster12146533fibster_
fibsters13126413fibsters
fifteen1343923fifteen
filter94517633filter_
filters103816553filters
fisher124917143fisher_
fishers134714723fishers
fishery16397733fishery
fisted104218703fiste_d
fitter94120033fitter_
fitters104517753fitters
foster94322223foster_
fosters104220103fosters
gaster75027353gaster_
gasters85624293gasters
gitterns9326573gitterns
glisten8418083gliste_n
glister84013343glister_
glisters93912603glisters
grister83915413grister_
gristers94013403gristers
hasten95718563haste_n
heister103613623heister_
heisters113413133heisters
hinter94021303hinter_
hinters103719583hinters
hipster12288783hipster_
hipsters13268793hipsters
hisser94713793hisser_
hissers104112313hissers
histed104420243histe_d
history1339423history
hitter94419863hitter_
hitters104717593hitters
hoister103714203hoister_
hoisters113513483hoisters
inter55028493_inter_
interne73218153_interne
interns73116773_interns
inters64328053_inters
inturn63411563_inturn
jester134319153jester_
jesters144118193jesters
jilter133512513jilter_
jilters144211963jilters
jitter133314993jitter_
jitters144314473jitters
jittery17346443jittery
juster134617013juster_
justers143815733justers
keister113011573keister_
keisters123212043keisters
kiester11329973kiester_
kiesters123310153kiesters
kilter103714343kilter_
kilters113813603kilters
kisser104212453kisser_
kissers114211293kissers
kiter95523213ki_ter_
kiters105218593ki_ters
kitten104611483kitte_n
klister113410643klister_
klisters123910483klisters
lantern7310013lantern
laster64830633laster_
lasters75627693lasters
lectern937033lectern
leister73212753leister_
leisters83312823leisters
lifter93814813lifter_
lifters104313783lifters
linter64625343linter_
linters73822633linters
lisper84114433lisper_
lispers94514323lispers
listed74322833liste_d
listee64223063liste_e
listees73416673listees
listel64214743liste_l
listels74212433listels
listens74014133listens
listeria839433listeria
liter54736343li_ter_
liters65429883li_ters
litten64014873litte_n
litter64324853litter_
litters73422573litters
littery103710493littery
luster64023673luster_
lusters73921443lusters
master84831343master_
masters94628923masters
mastery124214323mastery
meister93114163meister_
meisters103313843meisters
midterm12316013midterm
milter84921233milter_
milters93619093milters
minster93914323minster_
minsters103813923minsters
minter84425103minter_
minters93822473minters
miser75430403mis_er_
misers85025703mis_ers
misery114113543mis_ery
mislearn1045343mislearn
mispen10312173mispe_n
misted93625823miste_d
mistend103812523mistend
misterms123711353misterms
misteuk1335893misteuk
mistier93418713mistier_
miter75734793mi_ter_
miters84328783mi_ters
mitten83914093mitte_n
moisten93110143moiste_n
moister94015373moister_
muster84724523muster_
musters94522513musters
mystery15436523mystery
nester64124183nester_
nesters74422793nesters
niter55028973ni_ter_
niters64624213ni_ters
nitery94412173ni_tery
ouster64223733ouster_
ousters74122793ousters
oyster94111703oyster_
oysters103411693oysters
paster85734373paster_
pasterns104112623pasterns
pasters94531733pasters
pattern93712053pattern
pester84827593pester_
pesters93827093pesters
piaster93012883piaster_
piasters102912813piasters
pisher114317753pisher_
pishers123815753pishers
pisser84416383pisser_
pissers95014753pissers
piste75824603piste__
pistes85325633piste_s
piston83515923pist_on
posteen93512623posteen
poster84129173poster_
posterns102713723posterns
posters93928013posters
raster64731443raster_
rasters74629023rasters
rester63832433rester_
resters74130403resters
rioter64817283rioter_
rioters73615513rioters
risen54621883ris_e_n
riser55431053ris_er_
risers64624783ris_ers
risker105414493risker_
riskers114011993riskers
ristra6310713rist_ra
ritter63822423ritter_
ritters74020623ritters
roister73516203roister_
roisters83615553roisters
roster64329083roster_
rosters73727543rosters
saltern74010653saltern
sifter94516233sifter_
sifters103714793sifters
silvern10347143silvern
sinter63625923sinter_
sinters74024083sinters
sistered92612803sistered
sistering101213753sistering
sisterly1146333sisterly
sistra639333sist_ra
sitten64113823sitte_n
sitter63323383sitter_
sitters74221553sitters
sixteen1434113sixteen
stein54620543__stein
stere55328543__stere
sterna63712763__sterna
sterns64616763__sterns
taster64930573taster_
tasters74225643tasters
tern46134803___tern
tester64227153tester_
testers74124543testers
tilter63417693tilter_
tilters73315953tilters
tinter63923643tinter_
tinters74221113tinters
tipster9299053tipster_
tipsters10278513tipsters
titer55430613ti_ter_
titers64526413ti_ters
titter63421163titter_
titters74219623titters
twister10308953twister_
twisters11268173twisters
ulster63712103ulster_
ulsters72711983ulsters
vaster94521023vaster_
viscera1235083viscera
visiter1038863visiter_
visiters1137413visiters
waister103812383waister_
waisters113811523waisters
waster95228943waster_
wasters104026593wasters
wastery134610993wastery
wester94222893wester_
westerns11328963westerns
westers105221963westers
winter94222803winter_
winters103720483winters
wintery13399753wintery
wiser85522803wis_er_
wisher123617063wisher_
wishers133215213wishers
wisted104120273wiste_d
wisteria1147753wisteria
wivern12409283wi_vern
xyster16366803xyster_
xysters17307163xysters
yester93417983yester_
zester153617793zester_
zesters163517293zesters
zithern19447023zithern
zoster153715853zoster_
zosters163015413zosters

Search took 8 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.420425454.8
2DLD Change Limit1340274226.78319759.3
3Display Results4224220.1562705.1
 (SQL Overall)1786914227.35924282.0
 
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.