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

109 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
listeria83943(None) 
listerias959231listerias
wisteria1147751wisteria
asteria7316182_asteria
cisterna10376362cisterna
hysteria1447392hysteria
lister64527252lister__
listers74026532lister_s
wistaria1146622wistaria
wisterias1248102wisterias
apteria9312913_apteria
asterias8317013_asterias
bacteria1248983bacteria
bister84922763bister__
bistered112913333bistered
bisters93922613bister_s
blister94415313blister__
blistered12167683blistered
blistering13107063blistering
blisters104015083blister_s
blistery13418713blister_y
cistern93310703cister_n
cisternae11265093cisternae
cisternal11325743cisternal
cisterns10369573cisterns
criteria1047993criteria
diptera1037213dipter_a
disherit12412523disherit
episterna1143373episterna
gesneria944053gesneria
glister84013343glister__
glistered11176293glistered
glistering12106423glistering
glisters93912603glister_s
hatteria1137863hatteria
historian12128103historian
historic1388943historic
hysterias1547153hysterias
hysteric1647533hysteric
icteric1138023_icteric
imperia1148423_imperia
interim9912873_interim
klister113410643klister__
klisters123910483klister_s
laster64830633laster__
lasters75627693laster_s
latria62313593l_at_ria
leister73212753leister__
leistered1037043leistered
leistering1147983leistering
leisters83312823leister_s
lictorian1166603lictorian
lifter93814813lifter__
lifters104313783lifter_s
lingerie959203lingerie
linter64625343linter__
linters73822633linter_s
lisper84114433lisper__
lispers94514323lisper_s
listed74322833liste__d
listee64223063liste__e
listees73416673liste_es
listel64214743liste__l
listels74212433liste_ls
listen64816813liste__n
listened9168813listened
listener8158313listener
listening10128953listening
listens74014133liste_ns
liter54736343li_ter__
literal7613273li_teral
liters65429883li_ter_s
lithemia1345253lithemia
lithia939333li_t_hia
litter64324853litter__
litterbag1242793litterbag
littered92511383littered
litterer82810173litterer
littering102411983littering
litters73422573litter_s
littery103710493litter_y
luster64023673luster__
lustered92510603lustered
lustering102711203lustering
lusters73921443luster_s
lustra6358893lust_r_a
mister84728563mister__
misterm114314513mister_m
misterms123711353misterms
misters93927513mister_s
mistrial10311383mist_rial
niterie7313743ni_terie
pizzeria1842433pizzeria
ristra6310713rist_r_a
santeria8311653santeria
sestertia945423sestertia
sister64421583sister__
sistered92612803sistered
sistering101213753sistering
sisterly1146333sisterly
sisters73721593sister_s
sistra639333sist_r_a
steric8317063__steric
sterna63712763__sterna
stria55723213__st_ria
victoria1346313victoria
viscera1235083viscer_a
wasterie111211583wasterie
wistarias1246793wistarias

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.423422437.4
2DLD Change Limit1461621097.75018859.6
3Display Results1091090.0462369.6
 (SQL Overall)1786911098.21921741.2
 
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.