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

102 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
lusus5481387(None) 
luaus54514901luaus
lulus54315161lulus
lupus74512521lupus
lusts55022801lusts
bubus95115452bubus
buses75936012buses
busks115521372busks
buss65134912bus_s
busts75227692busts
casus76419252casus
cuscus1038112cuscus
cusks114916052cusks
cusps94913672cusps
cuss65430612cus_s
dufus94010812dufus
dusks105317252dusks
dusts65923562dusts
fucus105515892fucus
fugus95914012fugus
fuses85628422fuses
fuss76027932fus_s
gurus64318192gurus
gusts65722792gusts
humus106215072humus
husks125015452husks
jujus11347462jujus
jukus16398672jukus
justs124918262justs
kudus104910802kudus
kurus98015632kurus
lapsus8437272lapsus
lases54944762lases
lass47444542las_s
lasts57731262lasts
leses54930812leses
less45635102les_s
lieus56218482lieus
lisps76913912lisps
lists56628692lists
locus74819992locus
loses56742012loses
loss45337962los_s
lotus55718062lotus
louses66230282louses
luau44824162luau_
lubes74727992lubes
luces75528432luces
lucks115723562lucks
ludes65728852ludes
lues45943552lu_es
luffs114516282luffs
luges65928752luges
lugs55233522lu_gs
lulls54119652lulls
lulu44122882lulu_
lumas75622912lumas
lumps95624982lumps
lums65734242lu_ms
lunas55025012lunas
lunes55337772lunes
lungs65223882lungs
lunks94822452lunks
lunts55826902lunts
lupous849432lupous
lures56138532lures
lurks95218742lurks
lush75327692lus_h
lushes94022742lushes
lust47442602lus_t
lusty85417572lusty
lususes736712lususes
lutes55836662lutes
luvs75818502lu_vs
luxes124921502luxes
lyses84518252lyses
lysis84511462lysis
mucus94015742mucus
mumus95517282mumus
muses75134302muses
musks116119642musks
muss64933762mus_s
musts75527442musts
nisus56014392nisus
ousts55225702ousts
pluses83618072pluses
pupus94614042pupus
puses75532202puses
puss64830132pus_s
risus54216392risus
rubus76415062rubus
ruses56136582ruses
rusks95816192rusks
rusts55026992rusts
sulus54821882sulus
suss45229302sus_s
tusks94915532tusks
tutus55214812tutus
ulus45622562_ulus
urus46426142_urus
uses44931112_uses
wuss75219332wus_s

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.296603685.8
2DLD Change Limit538001021.62633087.3
3Display Results1021020.0303400.0
 (SQL Overall)1786911021.95291542.5
 
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.