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

185 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
filles9422452(None) 
failles102914121failles
files85441271fi_les
fille84327401fille_
filled104922261filled
filler94623621filler
fillers104320201fillers
fillet95027081fillet
fillets103414751fillets
fillies103420251fillies
fillos94415071fillos
fills84632371fill_s
folles93820471folles
milles84526561milles
rilles64725501rilles
aisles64721142aisles
belles85325992belles
bibles104617642bibles
biles75542142bi_les
bilges94915632bilges
billed94224902billed
biller84923482biller
billers94720822billers
billet86029722billet
billets94516152billets
billies93923502billies
bills75632862bill_s
birles84920642birles
dalles74222062dalles
dilled84122222dilled
dillies84122152dillies
dills65530972dill_s
fables114921672fables
faille93414742faille_
falces115216002falces
fallen93813372fallen
faller94621232faller
fallers103917992fallers
falls85727652fall_s
farles96025782farles
fellas95116962fellas
felled103720302felled
feller94419552feller
fellers104117542fellers
fellest10313752fellest
fellies104119742fellies
felloes104114372felloes
fells85327382fell_s
fibres114312122fibres
fices106031162fi_ces
fiches145219532fiches
ficoes114613462ficoes
fiddles123212602fiddles
fidges114114382fidges
fields104211042fields
fifes114822392fi_fes
filches153410722filches
file75446642fi_le_
filed95331902fi_led
filer85433002fi_ler
filers94623722filers
filet85540162fi_let
filets94718952filets
fill75540192fill__
fillip11268952fillip
fillips12298132fillips
fillo84319782fill_o
filly114424902fill_y
filmed124610362filmed
filmer114112402filmer
filmers124211292filmers
filmis114610282filmis
filmless1344552filmless
films105617962fi_lms
filos86125382fi_los
filose96112502filose
fils75838692fi_l_s
filter94517632filter
filters103816542filters
filths12389782filths
fimbles143510652fimbles
finales104016012finales
fines86644262fi_nes
finless102810782finless
fipples14298652fipples
fiques1837972fiques
fires85740752fi_res
fishes125221342fishes
fives116027362fi_ves
fixes154723592fi_xes
fizzes174512552fizzes
fizzles18339062fizzles
flees85828752f_lees
flies85630712f_lies
flites95122442flites
floes85528142f_loes
flues84626922f_lues
foibles1238852foibles
follies103618942follies
follis93113902follis
frilled113911602frilled
friller104111742friller
frillers11349862frillers
frills94414222frill_s
fugles104715782fugles
fulled103820652fulled
fuller94220382fuller
fullers103817372fullers
fullest10313342fullest
fulls84623522full_s
gilled84521632gilled
giller74519732giller
gillers84216892gillers
gillies84120962gillies
gills64728192gill_s
grilles83715022grilles
hilled104022222hilled
hiller94421632hiller
hillers103718722hillers
hilloes103815942hilloes
hillos94618882hillos
hills85431352hill_s
idles66720122_idles
iller54821292_iller
illest63615722_illest
ills47030422_ill_s
isles54220562_isles
jills125122822jill_s
killed113918772killed
killer104917952killer
killers114215572killers
killies113318112killies
kills94526172kill_s
lilies63021412lilies
lisles63416282lisles
miles74645072mi_les
mille75029132mille_
milled94326172milled
miller84625412miller
millers93621332millers
millet84030742millet
millets94216842millets
mills75435052mill_s
nilled73919452nilled
nills54926672nill_s
piles74742612pi_les
pilled94222752pilled
pills74130972pill_s
pilules9510622pilules
rifles94217702rifles
riles55343642ri_les
rille55728732rille_
rilled74525652rilled
rillet64828852rillet
rillets74216152rillets
rills55032712rill_s
selles64426982selles
sidles74721152sidles
siller64026052siller
sillers73822092sillers
sillies73425072sillies
sills55135982sill_s
tailles72516462tailles
tildes74513962tildes
tiles55542102ti_les
tilled74722952tilled
tiller64222532tiller
tillers73418732tillers
tills54631702till_s
titles63719922titles
tuilles72411922tuilles
tulles63218892tulles
villas96117262villas
vills86429322vill_s
villus93611222villus
wiles85437872wi_les
willed104722452willed
willer94021062willer
willers103517902willers
willet95124832willet
willets104414322willets
willies103920152willies
wills84528962will_s
yills83921552yill_s
zills144020782zill_s

Search took 4 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 Filter178691825510.233766914.2
2DLD Change Limit825511853.14026290.1
3Display Results1851850.0632936.5
 (SQL Overall)1786911853.43652005.5
 
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.