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

157 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
lilos5582187(None) 
filos86125381filos
kilos95021471kilos
lidos65219881lidos
lilo46731561lilo_
lilts55822801lilts
limos75320811limos
linos55631501linos
milos75428011milos
silos56029421silos
ails45654712ail_s
aliyos9349532aliyos
bigos85020012bigos
bilbos105011192bilbos
biles75542142biles
bilks115117892bilks
bills75632862bills
bios66335312bi_os
biros75325132biros
bolos75531372bolos
calos74431902calos
didos76820812didos
dildos8179302dildos
dills65530972dills
dinos65428062dinos
diols65521012diols
eidos65817752eidos
fidos95819052fidos
files85441272files
fillos94415072fillos
fills84632372fills
films105617962films
filo76034282filo_
filose96112502filose
fils75838692fil_s
finos86226952finos
gilds75417522gilds
gills64728192gills
gilts64924262gilts
giros65722652giros
halos85230252halos
helos84928062helos
hillos94618882hillos
hills85431352hills
hilts86924412hilts
hilus84817642hilus
ilks87218572_ilks
ills47030422_ills
jills125122822jills
jilts124717412jilts
kills94526172kills
kilns95112982kilns
kilo86028662kilo_
kilts95122182kilts
kinos96626142kinos
kolos94921212kolos
lalls55324132lalls
lenos56024862lenos
liars54723162liars
libs66732752li_bs
licks115325392licks
lido56028152lido_
lids56336452li_ds
liens56525502liens
liers55130402liers
lies46454192li_es
lieus56218482lieus
lifts85719062lifts
likes96231902likes
lilac7311072lilac
lilacs837482lilacs
lilies63021412lilies
lilt46349942lil_t
lily76730182lil_y
limas75627632limas
limbos104712132limbos
limbs96118932limbs
limes75636502limes
limns75718392limns
limo65529732limo_
limps95522672limps
lines57054572lines
lings67135772lings
links96430192links
linns56123332linns
lino46343372lino_
lins47059052li_ns
lints57137192lints
lion46334442li_on
lions55923212lions
lips67141442li_ps
liras56021982liras
lirot5430032lirot
lis37162272li__s
lisles63416282lisles
lisps76913902lisps
lists56628692lists
litas54923772litas
lithos94212552lithos
lits46252492li_ts
lives86133192lives
lobos75921842lobos
locos75822602locos
logos67225332logos
lolls512121732lolls
loos49051122l_oos
lotos54724632lotos
lulls54119652lulls
lulus54315162lulus
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milo65536092milo_
mils66045322mil_s
milts75430712milts
misos76523292misos
nills54926672nills
nils46132452nil_s
nolos54423352nolos
oils46337972oil_s
olios54520852oli_os
piles74742612piles
pilis75825202pilis
pills74130972pills
pilose84514232pilose
pilot77435062pilot
pilots84018872pilots
pilous84717752pilous
pilus75921062pilus
pisos76021062pisos
polos76129912polos
riles55343642riles
rills55032712rills
siglos7311462siglos
silds65520522silds
silks94620682silks
sills55135982sills
silo46037912silo_
silts55330822silts
solos54830792solos
telos55424522telos
tiles55542102tiles
tills54631702tills
tils45739612til_s
tilts55325612tilts
tiros54524892tiros
vills86429322vills
vinos84723072vinos
viols86118102viols
wilds94818202wilds
wiles85437872wiles
wills84528962wills
wilts85023502wilts
winos84625042winos
yills83921552yills
zills144020782zills

Search took 3 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.0802233637.5
2DLD Change Limit538001571.84329191.5
3Display Results1571570.0602616.7
 (SQL Overall)1786911571.98390111.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.