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

261 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
cisterns1036957(None) 
cistern93310701cistern_
cisterna10376361cisterna
citterns10318121citterns
bisters93922612bister_s
bitterns10428952bitterns
caserns94711222cas_erns
casters94729902caster_s
cisternae11265092cisternae
cisternal11325742cisternal
cistrons102710622cistrons
citers85022982ci_ter_s
citherns13338872citherns
cittern9339142cittern_
costers94128332coster_s
cysteins1355732cysteins
discerns1138162discerns
gitterns9326572gitterns
interns73116772_interns
listens74014132liste_ns
listers74026532lister_s
misterms123711352misterms
misters93927512mister_s
pasterns104112622pasterns
posterns102713722posterns
sisters73721592sister_s
sterns64616762__sterns
westerns11328962westerns
astern64815813_astern_
asters65631603_aster_s
basters94930303baster_s
bister84922763bister__
bistered112913323bistered
bistorts10118813bistorts
bistres94017213bist_res
bistros92810983bist_ros
biters83925243bi_ter_s
bittern94810683bittern_
bitters94920363bitter_s
blisters104015083blister_s
busters94724133buster_s
canisters112310193canister_s
canteens1038573canteens
canters94827733canter_s
carters95327253carter_s
caseins93115053cas_eins
casern84713313cas_ern_
caserne93710063cas_erne
casernes103810753cas_ernes
caster85232573caster__
castes85631863caste__s
castors94919443castor_s
caterans10313223c_aterans
caters85336503c_ater_s
caverns124510253c_averns
centers94420603center_s
chastens13429183chaste_ns
chitters133711173chitter_s
christens14125413christe_ns
ciceros1158583ci_ceros
ciders94620093ci_der_s
cinders104617763cinder_s
cinerins10414103ci_nerins
ciphers14379993cipher_s
cisted95217523ciste__d
cistron9299883cist_ron
cists76624533cist___s
cistus84611343cist__us
cistuses1038283cistuses
citer74827333ci_ter__
cites74435593ci_te__s
cithern12489913cithern_
cithers124315773cither_s
cithrens13355933ci_threns
citrins92614363ci_trins
citrons92913223ci_trons
citrus83610923ci_t_rus
cloisters1137433cloister_s
clusters102912403cluster_s
clysters13227843clyster_s
coasters104317333coaster_s
coaters93525793coater_s
cointers103616413cointer_s
coistrels1145263coistrels
colters93522443colter_s
concerns122710833concerns
contemns1237403contemns
cooters94525723cooter_s
copters113621283copter_s
coshers123618183cosher_s
costards113510793costards
costars94218013costar_s
coster84331293coster__
costrels1038933costrels
cotters94323443cotter_s
couters93827303couter_s
craters95021893crater_s
crispens12286253crispe_ns
crispers12309433crisper_s
critters103511323critter_s
cussers94213403cusser_s
custards11338393custards
cutters94218963cutter_s
cystein1246053cystein_
cysteine1345333cysteine
cysteines1445143cysteines
diasters92913183diaster_s
diesters92513603diester_s
dieters83216433dieter_s
dipterans1245723dipterans
discern1038493discern_
disserts92411813disserts
distains9413603distains
distend93312073diste_nd
distends10339823distends
distent84120853diste_nt
distorts91112353distorts
distress9311713distress
disturbs1145403disturbs
dusters84918363duster_s
eastern74412533eastern_
easters75125683easter_s
einsteins944153einsteins
eisweins1143383eisweins
episterna1143373episterna
esters64627733_ester_s
externs1438233_externs
fastens105511753faste_ns
festers104121393fester_s
fibsters13126413fibster_s
fifteens1442753fifteens
filters103816553filter_s
fishers134714723fisher_s
fitters104517753fitter_s
fosters104220103foster_s
gasters85624293gaster_s
gittern8337503gittern_
glistens9366593gliste_ns
glisters93912603glister_s
gristers94013403grister_s
hastens106214813haste_ns
heisters113413133heister_s
hinters103719583hinter_s
hipsters13268793hipster_s
hissers104112313hisser_s
hitters104717593hitter_s
hoisters113513483hoister_s
icterus936073_icterus
intern64016543_intern_
interne73218143_interne
internes82721233_internes
inters64328053_inter_s
inturns73210133_inturns
jesters144118193jester_s
jilters144211963jilter_s
jitters144314473jitter_s
justers143815733juster_s
keisters123212043keister_s
kiesters123310153kiester_s
kilters113813603kilter_s
kissers114211293kisser_s
kiters105218593ki_ter_s
kittens11347583kitte_ns
klisters123910483klister_s
lanterns838303lanterns
lasters75627693laster_s
lecterns1035943lecterns
leisters83312823leister_s
lifters104313783lifter_s
linters73822633linter_s
lispers94514323lisper_s
listees73416673liste_es
listels74212433liste_ls
listen64816813liste_n_
lister64527253lister__
listeria839433listeria
listerias959233listerias
liters65429883li_ter_s
litters73422573litter_s
lusters73921443luster_s
masters94628923master_s
meisters103313843meister_s
midterms13284863midterms
milters93619093milter_s
minsters103813923minster_s
minters93822473minter_s
misers85025703mis_er_s
mislearns1144523mislearns
mispens11311073mispe_ns
mistend103812523miste_nd
mistends11419593mistends
mister84728563mister__
misterm114314513mister_m
mistress10310703mistress
miters84328783mi_ter_s
mittens9349883mitte_ns
moistens10268773moiste_ns
musters94522513muster_s
nesters74422793nester_s
niters64624213ni_ter_s
ousters74122793ouster_s
oysters103411693oyster_s
pastern94415063pastern_
pasters94531733paster_s
patterns10439943patterns
pesters93827093pester_s
piasters102912813piaster_s
pishers123815753pisher_s
pissers95014753pisser_s
pistes85325633piste__s
pistons93016373pist_ons
posteens10309733posteens
postern93615613postern_
posters93928013poster_s
rasters74629023raster_s
resters74130403rester_s
rioters73615513rioter_s
risers64624783ris_er_s
riskers114011993risker_s
ristras7311563rist_ras
ritters74020623ritter_s
roisters83615553roister_s
rosters73727543roster_s
salterns8388903salterns
sifters103714793sifter_s
sinters74024083sinter_s
sister64421583sister__
sistered92612803sistered
sistering101213753sistering
sisterly1146333sisterly
sitters74221553sitter_s
sixteens1542943sixteens
steins64818343__steins
steres63929533__steres
stern55319123__stern_
sterna63712763__sterna
tasters74225643taster_s
terns55226873___terns
testers74124543tester_s
tilters73315953tilter_s
tinters74221113tinter_s
tipsters10278513tipster_s
titers64526413ti_ter_s
titters74219623titter_s
twisters11268173twister_s
ulsters72711983ulster_s
visiters1137413visiter_s
waisters113811523waister_s
wasters104026593waster_s
western102911093western_
westers105221963wester_s
winters103720483winter_s
wishers133215213wisher_s
wisteria1147753wisteria
wisterias1248103wisterias
wiverns13366963wi_verns
xysters17307163xyster_s
yestern10338633yestern_
zesters163517293zester_s
zitherns20376133zitherns
zosters163015413zoster_s

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622617.17020385.2
3Display Results2612610.0932806.5
 (SQL Overall)1786912617.68623248.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.