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

186 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
filos8612538(None) 
fidos95819051fidos
files85441271files
fillos94415081fillos
fills84632371fills
films105617961films
filo76034281filo_
filose96112501filose
fils75838691fil_s
finos86226951finos
kilos95021471kilos
lilos55821871lilos
milos75428011milos
silos56029431silos
ails45654712ail_s
bigos85020012bigos
bilbos105011202bilbos
biles75542142biles
bilks115117892bilks
bills75632862bills
bios66335322bi_os
biros75325132biros
bolos75531372bolos
calos74431902calos
didos76820812didos
dildos8179302dildos
dills65530972dills
dinos65428062dinos
diols65521012diols
eidos65817752eidos
fados95620732fados
fails85631482fail_s
falls85727652falls
fanos85926502fanos
faros85532022faros
fells85327382fells
felon84619292felon
felons93615762felons
felts85324542felts
fiars86720832fiars
fiats85324482fiats
fibs96329502fi_bs
fices106031162fices
fico95824592fico_
ficoes114613462ficoes
ficus105015492ficus
fido87726402fido_
fids87034742fi_ds
fiefs116213702fiefs
fields104211042fields
fifes114822392fifes
figs85332642fi_gs
fil65447142fil__
fila74729132fil_a
filar84819292filar
filch134813322filch
file75446642fil_e
filed95331902filed
filer85433002filer
filers94623722filers
filet85540162filet
filets94718952filets
fill75540192fil_l
fille84327402fille
filles94224522filles
fillo84319782fillo
filly114424902filly
film94828172fil_m
filmi105914002filmi
filmis114610282filmis
filmy136114042filmy
filth115015822filth
filths12389782filths
filum105015432filum
finds95424822finds
fines86644262fines
finis86824262finis
finks125424222finks
fino76034692fino_
fins75849092fi_ns
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fi_rs
fiscs105311882fiscs
fists85527542fists
fits76043462fi_ts
fives116027362fives
fixes154723592fixes
flics105418362flics
flies85630712flies
flips105117742flips
flirs85518932flirs
flits85625222flits
floc95922122f_loc
flocs105519232f_locs
floe76129772f_loe
floes85528142f_loes
flog85523892f_log
flogs95919962f_logs
flop96925452f_lop
flops105920142f_lops
floss85118262f_loss
flow105924922f_low
flows115822362f_lows
flus75626542f_lus
foils85025812foil_s
folds95221692folds
folios93915462folios
folks126017122folks
fools86824202fools
frills94414222frills
fulls84623522fulls
gilds75417522gilds
gills64728192gills
gilts64924262gilts
giros65722652giros
halos85230252halos
helos84928062helos
hillos94618892hillos
hills85431352hills
hilts86924412hilts
hilus84817642hilus
ilks87218572_ilks
ills47030422_ills
jills125122822jills
jilts124717412jilts
kills94526172kills
kilns95112982kilns
kilo86028672kilo_
kilts95122182kilts
kinos96626142kinos
kolos94921212kolos
lidos65219882lidos
lilo46731562lilo_
lilts55822802lilts
limos75320812limos
linos55631502linos
milds86422052milds
miles74645072miles
milks115020582milks
mills75435052mills
milo65536102milo_
mils66045332mil_s
milts75430712milts
misos76523292misos
nills54926672nills
nils46132452nil_s
nolos54423352nolos
oils46337972oil_s
olios54520852olios
piles74742612piles
pilis75825202pilis
pills74130972pills
pilose84514242pilose
pilot77435062pilot
pilots84018872pilots
pilous84717752pilous
pilus75921062pilus
pisos76021062pisos
polos76129912polos
riles55343642riles
rills55032712rills
siglos7311472siglos
silds65520522silds
silks94620682silks
sills55135992sills
silo46037912silo_
silts55330822silts
solos54830792solos
telos55424522telos
tiles55542102tiles
tills54631712tills
tils45739612til_s
tilts55325612tilts
tiros54524892tiros
vills86429322vills
vinos84723072vinos
viols86118102viols
wilds94818202wilds
wiles85437872wiles
wills84528962wills
wilts85023502wilts
winos84625042winos
yills83921552yills
zills144020782zills

Search took 5 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.343520965.0
2DLD Change Limit538001863.31316239.1
3Display Results1861860.500372.0
 (SQL Overall)1786911864.15642995.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.