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

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

271 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
fillips1229813(None) 
fillies103420251fillies
fillip11268951fillip_
billies93923502billies
dillies84122162dillies
fellies104119742fellies
fillers104320212fillers
filles94224522fill_es
fillets103414752fillets
filling113520802filling
fillings122910502fillings
filliped1435222filliped
fillos94415082fill_os
fills84632372fill__s
filmis114610282filmi_s
flips105117742f__lips
follies103618942follies
follis93113902folli_s
gillies84120962gillies
killies113318112killies
riflips1234162riflips
sillies73425082sillies
willies103920152willies
aiblins9311473aiblins
aiolis6316843aioli_s
allies63827673_allies
ballies93725743ballies
bellies94023723bellies
bialies93618413bialies
bialis83617163biali_s
bilbies114712343bilbies
billers94720833billers
billets94516153billets
billie85019173billi_e
billing103823853billing
billings113412633billings
billion92212173billion
billions102211793billions
billons93013363billons
billows123611293billows
bills75632863bill__s
blips95615783__blips
bullies94121893bullies
chillies134113483chillies
chillis124411603chilli_s
clips96018303__clips
collies94326583collies
collins93419833collins
collops112611753collops
cullies94419963cullies
cullis84115993culli_s
dallies84023193dallies
dellies83622213dellies
dills65530973dill__s
dollies83620983dollies
dollops10287963dollops
ellipse944013_ellipse
failles102914133faill_es
fallals103310193fallals
fallers103917993fallers
falling113621583falling
fallows133713973fallows
falls85727653fall__s
falsies103515013falsies
felids103111623f_elids
fellahs13428393fellahs
fellas95116963fell_as
fellers104117543fellers
felling113321133felling
felloes104114383felloes
fellows134212433fellows
fells85327383fell__s
ferlies103216693ferlies
fibrils1236843fibrils
fibrins1238643fibrins
ficins113513983fi_cins
fields104211043fiel_ds
fifties132111083fifties
filches153410723filches
filers94623723fi_lers
files85441273fi_l_es
filets94718953fi_lets
filial93013253fi_lial
filing103823763fi_ling
filings115213073filings
fill75540203fill___
fille84327403fill__e
filled104922263fill_ed
filler94623623fill_er
fillet95027083fill_et
filliping1544233filliping
fillo84319783fill__o
filly114424903fill__y
filmers124211293filmers
filmi105914003filmi__
filmic13348453filmi_c
filmier1237503filmier
filmiest1338553filmiest
filmily1535733filmily
filming133210353filming
filmless1344553filmless
filmlike1734443filmlike
films105617963fi_l_ms
filos86125383fi_l_os
fils75838703fi_l__s
filters103816553filters
filths12389783fi_lths
finalis103313663finali_s
finis86824263fi_ni_s
finless102810783finless
finlike14279063finlike
firkins1437663firkins
fizgigs2142203fizgigs
flails94313003f_lails
flairs95711913f_lairs
flaps105621383f__laps
flics105418363f__lics
flies85630713f__lies
flip96324263f__lip_
flirs85518933f__lirs
flits85625223f__lits
flops105920143f__lops
fluids10349423f_luids
flumps135112503f_lumps
foldups1332733foldups
folios93915463f_olios
folkies143612253folkies
folles93820473foll_es
follows13409923follows
frillers11349873frillers
frillier1136513frillier
frilliest1237113frilliest
frilling123011493frilling
frillings13265803frillings
frills94414223frill__s
frolics1236833frolics
fulfils1345723fulfils
fullams1236553fullams
fullers103817373fullers
fulling114019703fulling
fulls84623523full__s
fusillis1143563fusilli_s
gallies84122713gallies
gallops103211653gallops
ghillies12408663ghillies
gillers84216903gillers
gillie74816943gilli_e
gillied95512313gillied
gilling93520383gilling
gills64728193gill__s
girlies83013703girlies
gullies84717313gullies
hillers103718733hillers
hillier103413963hillier
hilliest113914113hilliest
hilling113821773hilling
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hill_os
hills85431353hill__s
hilltops1344933hilltops
hollies103420813hollies
illite63414923_illite
illites72415013_illites
ills47030423_ill__s
inclips1135963inclips
jellies143816533jellies
jillion14188933jillion
jillions15178283jillions
jills125122823jill__s
jollies143516273jollies
kellies113516853kellies
kilims1277903ki_lims
killers114215583killers
killick1295313killick
killicks1354873killicks
killie104114893killi_e
killing123118723killing
killings133710483killings
kills94526183kill__s
kilties113014143kilties
lilies63021413li_lies
lilliput1044193lilliput
lilliputs1142143lilliputs
lips67141453___lips
lollies73116923lollies
lollops9227443lollops
millers93621343millers
milles84526563mill_es
millets94216843millets
millier93716703millier
milliers102611903milliers
millime112511403millime
millimes122411373millimes
milline92519123milline
millines102718073millines
milling103223683milling
millings113712583millings
million91813143million
millions101712433millions
milliped1337383milliped
millipeds1444703millipeds
mills75435053mill__s
mislies92922283mislies
mollies93420233mollies
nellies73418723nellies
nilling83619563nilling
nills54926673nill__s
oilcups1143333oilcups
oxlips1544433_oxlips
pileups11365433pileups
pilis75825203pi_li_s
pillars9313493pillars
pilling103722563pilling
pillion92011713pillion
pillions101610933pillions
pillows122610123pillows
pills74130973pill__s
pullups1134233pullups
rallies73823343rallies
riflip1134723riflip_
rilles64725503rill_es
rillets74216153rillets
rilling84023623rilling
rills55032713rill__s
sallies73227813sallies
sialids839723sialids
silkies113715693silkies
sillers73822103sillers
sillier74017593sillier
silliest84017103silliest
sillily10209783sillily
sills55135993sill__s
silvics1235563silvics
simlins9311843simlins
slips76023723__slips
sullies74122233sullies
tallies73624603tallies
tallis63319963talli_s
tallits73215993tallits
tellies73820513tellies
tillers73418743tillers
tilling83522783tilling
tillite7313563tillite
tillites8312833tillites
tills54631713till__s
tulips8137253_tulips
unclips1136433unclips
villains1138013villains
villas96117263vill_as
villeins1136043villeins
villi86517853villi__
villous102810023villous
vills86429323vill__s
villus93611223vill_us
violins10311453violins
wallies103320743wallies
wallops123410413wallops
wellies103719073wellies
willers103517913willers
willets104414323willets
willie94116453willi_e
willied114611563willied
willing113821613willing
willows13299753willows
wills84528963will__s
yills83921553yill__s
zillahs1935383zillahs
zillion16188773zillion
zillions17168073zillions
zills144020783zill__s

Search took 7 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 Filter1786911340270.403443402.0
2DLD Change Limit1340272716.16021757.6
3Display Results2712710.1062556.6
 (SQL Overall)1786912716.66926794.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.