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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

133 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
lisps7691391(None) 
limps95522671limps
lips67141441li_ps
lisp68926881lisp_
lists56628691lists
wisps105214181wisps
asps65622092_asps
bises75435622bises
bisks115416802bisks
blimps12588152blimps
blips95615782bli_ps
bliss75616912blis_s
cists76624532cists
clasps104512092clasps
clips96018302cli_ps
crisps104411512crisps
cusps94913672cusps
dips75536912di_ps
discs85316262discs
disks105417472disks
diss56434482dis_s
fiscs105311882fiscs
fists85527542fists
flips105117742fli_ps
gasps85415482gasps
gimps105915202gimps
gips75632922gi_ps
gists66026192gists
hasps105114642hasps
hips96433702hi_ps
hiss75629212his_s
hists86328372hists
imps86221122_imps
isms66213472_isms
jisms14458002jisms
kips106430512ki_ps
kiss85227392kis_s
kists95822112kists
lamps95624832lamps
laps66848872l_aps
lases54944762lases
lass47444542las_s
lasts57731262lasts
leaps75522932leaps
leses54930812leses
less45635102les_s
liars54723162liars
libs66732762li_bs
licks115325392licks
lidos65219882lidos
lids56336452li_ds
liens56525502liens
liers55130402liers
lies46454192li_es
lieus56218482lieus
lifts85719062lifts
likes96231902likes
lilos55821872lilos
lilts55822802lilts
limas75627632limas
limbs96118942limbs
limes75636502limes
limns75718392limns
limos75320812limos
limp88432492limp_
limpa97014462limpa
limpas105513082limpas
limpsy13516842limpsy
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
linos55631502linos
lins47059052li_ns
lints57137192lints
lions55923212lions
lip514755802li_p_
lipa68425922li_pa
lipe66839732li_pe
lippy124511902lippy
liras56021982liras
lis37162272li__s
lisle53916722lisle
lisles63416282lisles
lisped94113422lisped
lisper84114432lisper
lispers94514322lispers
list47055342lis_t
litas54923772litas
lits46252492li_ts
lives86133192lives
loops75723962loops
lops66043352l_ops
loses56742012loses
loss45337962los_s
loups75319622loups
lumps95624982lumps
lusts55022802lusts
lusus54813872lusus
lyses84518252lyses
lysis84511462lysis
mips85534082mi_ps
mises74740562mises
misos76523292misos
miss65339422mis_s
mists76633902mists
nips65830922ni_ps
nisus56014392nisus
pimps114616982pimps
pips85837132pi_ps
pisos76021062pisos
piss65033332pis_s
rasps74316662rasps
rips66237432ri_ps
rises55244042rises
risks94917062risks
risus54216392risus
simps94719762simps
sips65740102si_ps
sises55233832sises
slips76023722sli_ps
tips66436762ti_ps
visas84317652visas
vises84427772vises
wasps106714692wasps
wimps125213802wimps
wises85633192wises
wisp97124072wisp_
wispy137210972wispy
wiss75630542wis_s
wists86728522wists
yips95226702yi_ps
zips155723792zi_ps

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001331.68631909.8
3Display Results1331330.0462891.3
 (SQL Overall)1786911331.82597912.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.