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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
cisterna1037636(None) 
cistern93310701cistern_
cisternae11265091cisternae
cisternal11325741cisternal
cisterns10369571cisterns
cittern9339142cittern_
citterns10318122citterns
episterna1143372episterna
listeria839432listeria
sterna63712762__sterna
wisteria1147752wisteria
asteria7316183_asteria
astern64815813_astern_
asternal858323_asternal
bister84922763bister__
bistered112913323bistered
bisters93922613bister_s
bittern94810683bittern_
bitterns10428953bitterns
casern84713313cas_ern_
caserne93710063cas_erne
caserns94711223cas_erns
cassena9287843casse_na
caster85232573caster__
casters94729903caster_s
catena8312483c_ate_na
cateran9313773c_ateran
cisted95217523ciste__d
cistron9299883cist_ron
cistrons102710623cistrons
citer74827333ci_ter__
citers85022983ci_ter_s
cithern12489913cithern_
citherns13338873citherns
coeternal1144303coeternal
coster84331293coster__
costers94128333coster_s
criteria1047993criteria
cystein1246053cystein_
cysteine1345333cysteine
cysteins1355733cysteins
diptera1037213dipter_a
dipteran1146203dipteran
discern1038493discern_
discerns1138163discerns
distend93312073diste_nd
distent84120853diste_nt
eastern74412533eastern_
gittern8337503gittern_
gitterns9326573gitterns
hysteria1447393hysteria
intern64016543_intern_
internal8414083_internal
interne73218143_interne
interns73116773_interns
listen64816813liste_n_
listens74014133liste_ns
lister64527253lister__
listerias959233listerias
listers74026533lister_s
mistend103812523miste_nd
mister84728563mister__
misterm114314513mister_m
misterms123711353misterms
misters93927513mister_s
pastern94415063pastern_
pasterns104112623pasterns
postern93615613postern_
posterns102713723posterns
presterna1145263presterna
ristra6310713rist_r_a
sister64421583sister__
sistered92612803sistered
sistering101213753sistering
sisterly1146333sisterly
sisters73721593sister_s
sistra639333sist_r_a
stern55319123__stern_
sternal73411913__sternal
sterns64616763__sterns
viscera1235083viscer_a
western102911093western_
westerns11328963westerns
wistaria1146623wistaria
wisterias1248103wisterias
yestern10338633yestern_

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.813219792.1
2DLD Change Limit146162867.65619091.2
3Display Results86860.0302866.7
 (SQL Overall)178691868.49921024.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.