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
cistern9331069(None) 
cisterna10376351cisterna
cisterns10369561cisterns
cittern9339131cittern
astern64815812_astern
bister84922762bister_
bisters93922602bisters
bittern94810682bittern
casern84713312cas_ern
caster85232572caster_
casters94729892casters
cisted95217522ciste_d
cisternae11265082cisternae
cisternal11325722cisternal
cistron9299882cistron
citer74827322ci_ter_
citers85022972ci_ters
cithern12489912cithern
citterns10318112citterns
coster84331292coster_
costers94128302costers
cystein1246052cystein
discern1038492discern
eastern74412532eastern
gittern8337502gittern
intern64016542_intern
listen64816812liste_n
lister64527252lister_
listers74026522listers
mister84728562mister_
misterm114314512misterm
misters93927502misters
pastern94415062pastern
postern93615602postern
sister64421582sister_
sisters73721572sisters
stern55319122__stern
western102911092western
yestern10338632yestern
aster55434893_aster_
asters65631603_asters
austere7312993austere
baster85333593baster_
basters94930303basters
bistered112913323bistered
bistort91216523bistort
bistre83815023bist_re
bistred103311853bistred
bistres94017213bistres
bistro8339943bist_ro
biter75030033bi_ter_
biters83925233bi_ters
bitten84715123bitte_n
bitter84622673bitter_
bitterns10428943bitterns
bitters94920353bitters
blister94415313blister_
blisters104015083blisters
blistery13418713blistery
buster84726493buster_
busters94724123busters
canister101710853canister_
canisters112310183canisters
canteen9411083canteen
canter85230113canter_
canters94827723canters
carter84932273carter_
carters95327243carters
casein83216453cas_ein
caserne93710063cas_erne
caserns94711213cas_erns
caste75932363caste__
castes85631863caste_s
castor84418533castor_
castors94919433castors
cater74840703c_ater_
cateran9313763c_ateran
caters85336493c_aters
cattery123811603cattery
cautery12349573cautery
cavern115312453c_avern
center84421413center_
centers94420593centers
chasten124312403chaste_n
chaster124718503chaster_
chitter124112963chitter_
chitters133711163chitters
christen13106703christe_n
cicero1048503ci_cero
cider84723313ci_der_
ciders94620083ci_ders
cinder94119123cinder_
cinders104617753cinders
cindery13429183cindery
cinerin9313823ci_nerin
cipher133710263cipher_
ciphers14379983ciphers
cist67244963cist___
cistrons102710623cistrons
cists76624533cist__s
cistus84611343cist_us
cite65640343ci_te__
cited84421953ci_te_d
cites74435583ci_te_s
cither114616683cither_
citherns13338863citherns
cithers124315753cithers
cithren12306593ci_thren
citrin82615403ci_trin
citron83112983ci_tron
cloister1037093cloister_
cloisters1137413cloisters
cluster94013323cluster_
clusters102912393clusters
clustery13317103clustery
clyster12317453clyster_
clysters13227823clysters
coaster94219033coaster_
coasters104317303coasters
coater84329553coater_
coaters93525773coaters
cointer93616723cointer_
cointers103616403cointers
coistrel1046733coistrel
colter84625093colter_
colters93522433colters
concern113011963concern
contemn1137803contemn
cooter85128613cooter_
cooters94525713cooters
copter109822013copter_
copters113621273copters
cosher114819903cosher_
coshers123618173coshers
cosier84423753cosier_
costar85518613costar_
costard104113353costard
costars94217993costars
costed95623113coste_d
costrel9310363costrel
cotter84926673cotter_
cotters94323433cotters
couter84930203couter_
couters93827283couters
crater85026633crater_
craters95021883craters
crispen11348203crispe_n
crisper113511053crisper_
crispers12309433crispers
critter94113033critter_
critters103511313critters
curter85320073curter_
cusser86016093cusser_
cussers94213393cussers
custard10389973custard
cuter74728223c_uter_
cutter84520993cutter_
cutters94218953cutters
cysteine1345333cysteine
cysteins1355733cysteins
diaster82813313diaster_
diasters92913173diasters
diester83013683diester_
diesters92513593diesters
dieter73516773dieter_
dieters83216423dieters
diptera1037203diptera
dipteran1146193dipteran
dipteron1145593dipteron
discerns1138163discerns
dissert83720693dissert
distain8313783distain
distend93312073distend
distent84120853distent
distort81120333distort
disturb1046233disturb
duster74919723duster_
dusters84918353dusters
easter65027983easter_
easters75125683easters
einstein844183einstein
eiswein1043503eiswein
episterna1143373episterna
ester54727713_ester_
esters64627733_esters
extern1348473_extern
fasten95114893faste_n
faster94625773faster_
fester94723513fester_
festers104121393festers
fibster12146533fibster_
fibsters13126403fibsters
fifteen1343923fifteen
filter94517633filter_
filters103816543filters
fisher124917143fisher_
fishers134714723fishers
fishery16397733fishery
fisted104218703fiste_d
fitter94120033fitter_
fitters104517743fitters
foster94322223foster_
fosters104220093fosters
gaster75027353gaster_
gasters85624283gasters
gitterns9326563gitterns
glisten8418083gliste_n
glister84013343glister_
glisters93912603glisters
grister83915413grister_
gristers94013403gristers
hasten95718563haste_n
heister103613623heister_
heisters113413133heisters
hinter94021303hinter_
hinters103719573hinters
hipster12288783hipster_
hipsters13268783hipsters
hisser94713793hisser_
hissers104112313hissers
histed104420243histe_d
history1339423history
hitter94419863hitter_
hitters104717583hitters
hoister103714203hoister_
hoisters113513473hoisters
inter55028493_inter_
interne73218143_interne
interns73116763_interns
inters64328043_inters
inturn63411563_inturn
jester134319153jester_
jesters144118193jesters
jilter133512513jilter_
jilters144211953jilters
jitter133314993jitter_
jitters144314463jitters
jittery17346443jittery
juster134617013juster_
justers143815723justers
keister113011573keister_
keisters123212043keisters
kiester11329973kiester_
kiesters123310143kiesters
kilter103714343kilter_
kilters113813593kilters
kisser104212453kisser_
kissers114211293kissers
kiter95523213ki_ter_
kiters105218583ki_ters
kitten104611483kitte_n
klister113410643klister_
klisters123910483klisters
lantern7310013lantern
laster64830633laster_
lasters75627693lasters
lectern937033lectern
leister73212753leister_
leisters83312823leisters
lifter93814813lifter_
lifters104313773lifters
linter64625333linter_
linters73822613linters
lisper84114433lisper_
lispers94514323lispers
listed74322833liste_d
listee64223063liste_e
listees73416673listees
listel64214733liste_l
listels74212433listels
listens74014133listens
listeria839423listeria
liter54736343li_ter_
liters65429873li_ters
litten64014873litte_n
litter64324853litter_
litters73422563litters
littery103710483littery
luster64023673luster_
lusters73921433lusters
master84831343master_
masters94628923masters
mastery124214323mastery
meister93114163meister_
meisters103313843meisters
midterm12316013midterm
milter84921233milter_
milters93619083milters
minster93914323minster_
minsters103813913minsters
minter84425103minter_
minters93822463minters
miser75430403mis_er_
misers85025703mis_ers
misery114113543mis_ery
mislearn1045343mislearn
mispen10312173mispe_n
misted93625823miste_d
mistend103812523mistend
misterms123711333misterms
misteuk1335893misteuk
mistier93418713mistier_
miter75734793mi_ter_
miters84328773mi_ters
mitten83914093mitte_n
moisten93110143moiste_n
moister94015373moister_
muster84724523muster_
musters94522493musters
mystery15436523mystery
nester64124183nester_
nesters74422783nesters
niter55028973ni_ter_
niters64624203ni_ters
nitery94412173ni_tery
ouster64223733ouster_
ousters74122773ousters
oyster94111703oyster_
oysters103411683oysters
paster85734373paster_
pasterns104112623pasterns
pasters94531733pasters
pattern93712053pattern
pester84827593pester_
pesters93827093pesters
piaster93012883piaster_
piasters102912803piasters
pisher114317753pisher_
pishers123815753pishers
pisser84416383pisser_
pissers95014753pissers
piste75824603piste__
pistes85325633piste_s
piston83515923pist_on
posteen93512613posteen
poster84129173poster_
posterns102713703posterns
posters93927993posters
raster64731443raster_
rasters74629023rasters
rester63832433rester_
resters74130403resters
rioter64817283rioter_
rioters73615503rioters
risen54621883ris_e_n
riser55431053ris_er_
risers64624783ris_ers
risker105414493risker_
riskers114011993riskers
ristra6310703rist_ra
ritter63822413ritter_
ritters74020613ritters
roister73516203roister_
roisters83615543roisters
roster64329083roster_
rosters73727533rosters
saltern74010653saltern
sifter94516233sifter_
sifters103714783sifters
silvern10347133silvern
sinter63625923sinter_
sinters74024073sinters
sistered92612803sistered
sistering101213733sistering
sisterly1146323sisterly
sistra639333sist_ra
sitten64113823sitte_n
sitter63323383sitter_
sitters74221543sitters
sixteen1434113sixteen
stein54620533__stein
stere55328543__stere
sterna63712763__sterna
sterns64616753__sterns
taster64930573taster_
tasters74225643tasters
tern46134803___tern
tester64227153tester_
testers74124543testers
tilter63417693tilter_
tilters73315933tilters
tinter63923643tinter_
tinters74221103tinters
tipster9299053tipster_
tipsters10278503tipsters
titer55430613ti_ter_
titers64526403ti_ters
titter63421163titter_
titters74219613titters
twister10308953twister_
twisters11268173twisters
ulster63712103ulster_
ulsters72711983ulsters
vaster94521023vaster_
viscera1235083viscera
visiter1038863visiter_
visiters1137403visiters
waister103812383waister_
waisters113811523waisters
waster95228943waster_
wasters104026593wasters
wastery134610993wastery
wester94222893wester_
westerns11328963westerns
westers105221963westers
winter94222803winter_
winters103720473winters
wintery13399743wintery
wiser85522803wis_er_
wisher123617063wisher_
wishers133215213wishers
wisted104120273wiste_d
wisteria1147743wisteria
wivern12409283wi_vern
xyster16366803xyster_
xysters17307163xysters
yester93417983yester_
zester153617793zester_
zesters163517293zesters
zithern19447023zithern
zoster153715853zoster_
zosters163015403zosters

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340274228.31316122.6
3Display Results4224220.1562705.1
 (SQL Overall)1786914228.62220725.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.