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

496 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
filmis11461028(None) 
filmi105914001filmi_
filmic13348451filmic
films105617961film_s
fermis114313502fermis
filers94623722filers
files85441272fil_es
filets94718952filets
filles94224522filles
fillies103420252fillies
fillip11268952fillip
fillips12298132fillips
fillos94415072fillos
fills84632372fil_ls
film94828172film__
filmed124610362filmed
filmer114112402filmer
filmers124211292filmers
filmier1237502filmier
filmiest1338552filmiest
filmily1535732filmily
filming133210352filming
filmy136114042film_y
filos86125382fil_os
fils75838692fil__s
filths12389782filths
finis86824262fi_nis
firms105217422firm_s
follis93113902follis
kilims1277902kilims
pilis75825202pil_is
salmis8514272salmis
aaliis6312893aaliis
ails45654713ail__s
aims67738183ai_m_s
aiolis6316843aiolis
alibis8311073alibis
almas76629773_almas
almes75126543_almes
alms65834923_alm_s
amis66445323__amis
animis84615943animis
balms95723923balm_s
bialis83617163bialis
bidis86721143bi_dis
bilbies114712343bilbies
bilbos105011193bilbos
biles75542143bil_es
bilges94915633bilges
bilks115117893bil_ks
billie85019173billie
billies93923503billies
bills75632863bil_ls
bimas95521743bi_mas
bindis94614583bindis
biomes103815253biomes
blimps12588153blimps
blinis85313683blinis
calms95222353calm_s
ceilis85413743ceil_is
chilis115517873chil_is
chillis124411603chillis
cilia73016763cil_ia
climbs12498723climbs
climes104720003climes
cullis84115993cullis
culms95314193culm_s
delis64928543del_is
dermis94717163dermis
diamin9312513diamin
diamins10312203diamins
diesis74013493diesis
dildos8179303dildos
dillies84122153dillies
dills65530973dil_ls
dimes85833043di_mes
dims75435023di_m_s
dismes95617673dismes
dismiss1038153dismiss
dolmas95213043dolmas
elemis8312383elemis
elms67322703_elm_s
failles102914123failles
fails85631483fail__s
falces115216003falces
falls85727653fal_ls
falsie93513853falsie
falsies103515013falsies
fames105735923f_ames
famish14311843f_amish
farms106324953farm_s
felid94717173fel_id
felids103111623felids
fellas95116963fellas
fellies104119743fellies
fells85327383fel_ls
felons93615763felons
felsic1147053felsic
felts85324543fel_ts
femes105626223f_emes
femmes135410213femmes
fems96428703f_em_s
fermi103914163fermi_
fiars86720833fi_ars
fiats85324483fi_ats
fibers114717523fibers
fibres114312123fibres
fibril1137163fibril
fibrils1236843fibrils
fibrin1138533fibrin
fibrins1238633fibrins
fibs96329503fi__bs
fices106031163fi_ces
fiches145219533fiches
fichus14388113fichus
ficin103516723fi_cin
ficins113513983ficins
ficoes114613463ficoes
ficus105015493fi_cus
fideism1335773fideism
fideist1139753fideist
fidges114114383fidges
fidos95819053fi_dos
fids87034733fi__ds
fiefs116213703fi_efs
fields104211043fields
fiends104110293fiends
fifers125414923fifers
fifes114822393fi_fes
fifths15406543fifths
fifties132111083fifties
fights133816553fights
figs85332643fi__gs
fil65447143fil___
fila74729133fil__a
filar84819293fil_ar
filaria1039653filaria
filch134813323fil_ch
filches153410723filches
file75446643fil__e
filed95331903fil_ed
filefish1745593filefish
filemot1246703filemot
filer85433003fil_er
filet85540163fil_et
filial93013253filial
filing103823763filing
filings115213073filings
fill75540193fil__l
fille84327403fil_le
filled104922263filled
filler94623623filler
fillers104320203fillers
fillet95027083fillet
fillets103414753fillets
filling113520803filling
fillings122910503fillings
fillo84319783fil_lo
filly114424903fil_ly
filmdom1562943filmdom
filmdoms1642503filmdoms
filminess1435983filminess
filmless1344553filmless
filmlike1734443filmlike
filmset1257513filmset
filmsets1353413filmsets
filo76034283fil__o
filose96112503filose
filter94517633filter
filters103816543filters
filth115015823fil_th
filthy15356423filthy
filum105015433fil_um
finalis103313653finalis
finals94316163finals
fincas113512073fincas
finds95424823fi_nds
fines86644263fi_nes
finfish16268193finfish
finish124613403fi_nish
finks125424223fi_nks
finless102810783finless
finos86226953fi_nos
fins75849093fi__ns
fiords10498623fiords
fiques1837973fiques
firers94922683firers
fires85740753fi_res
firkin1337823firkin
firkins1437663firkins
firm96026453firm__
firman112211343firman
firmans12238523firmans
firmed125411883firmed
firmer114712443firmer
firmers124711443firmers
firmest1239273firmest
firming132811223firming
firmly1436663firmly
firns86018543fi_rns
firs76637713fi__rs
firsts95110923firsts
firths125113503firths
fiscs105311883fi_scs
fishes125221343fishes
fistic11812573fistic
fists85527543fi_sts
fits76043463fi__ts
fivers124420923fivers
fives116027363fi_ves
fixers165112983fixers
fixes154723593fi_xes
fixit154819303fi_xit
fizgig2032973fizgig
fizgigs2142203fizgigs
fizzes174512553fizzes
flabs105818643f_labs
flags95321283f_lags
flail85316183f_lail
flails94313003f_lails
flair86114123f_lair
flairs95711913f_lairs
flames114723693flames
flams105125013f_lams
flans85327973f_lans
flaps105621383f_laps
flats86429743f_lats
flaws115920343f_laws
flays116321053f_lays
fleas86423663f_leas
flees85828753f_lees
flemish1536373flemish
flews115316443f_lews
fleys117015603f_leys
flic96223733f_l_ic
flicks154512993flicks
flics105418363f_lics
fliers94417193fliers
flies85630713f_lies
flimsies1335783flimsies
flimsy14345563flimsy
flings106715283flings
flints95617453flints
flip96324263f_l_ip
flips105117743f_lips
flir76422203f_l_ir
flirs85518933f_lirs
flirts95411483flirts
flit76539273f_l_it
flites95122443flites
flits85625223f_lits
flocs105519233f_locs
floes85528143f_loes
flogs95919963f_logs
flops105920143f_lops
floss85118263f_loss
flows115822363f_lows
flubs105515443f_lubs
flues84626923f_lues
fluid94013963f_luid
fluids10349423f_luids
fluish1239333f_luish
flumes115119733flumes
flumps135112503flumps
flus75626543f_l_us
foams105017953foam_s
foils85025813foil__s
folds95221693fol_ds
foleys123810463foleys
folia83618933fol_ia
folic105319323fol_ic
folio83820883fol_io
folios93915463folios
folkie13369613folkie
folkies143612253folkies
folkish1736563folkish
folks126017123fol_ks
folles93820473folles
follies103618943follies
formes114623713formes
formic13310453formic
forms105327053form_s
fortis95418613fortis
frames115119863frames
frills94414223fril_ls
frumps13479783frumps
fujis15379243f_ujis
fulfil1246423fulfil
fulfils1345723fulfils
fulgid1137043fulgid
fulls84623523ful_ls
fulmar1137253fulmar
fulmars1246423fulmars
fulmine1257963fulmine
fulmines1357783fulmines
fumes105224703f_umes
fusillis1143563fusillis
gilds75417523gil_ds
gillie74816943gillie
gillies84120963gillies
gills64728193gil_ls
gilts64924263gil_ts
gimmes113010903gimmes
gimmie11298183gimmie
gimmies123010113gimmies
gimps105915203gi_mps
gismos957183gismos
gizmos1844133gizmos
glimes94717523glimes
glims87417673glim_s
halmas117017893halmas
halms105225213halm_s
helms105619463helm_s
hili75626633hil_i_
hillos94618883hillos
hills85431353hil_ls
hilts86924413hil_ts
hilus84817643hil_us
hims95230973hi_m_s
holmic1338773holmic
holms105117803holm_s
iambs95815063_iambs
ibis66519583_i_bis
ileus54616893_ileus
ilia46026823_il_ia
ilks87218573_il_ks
ills47030423_il_ls
imid76122293_i_mid
imids86015143_i_mids
immies102412443_immies
immix1635033_immix
impis96213853_impis
imps86221123_i_mps
intis55121643_intis
iris45732553_i_ris
isms66213473_ism_s
iwis77117013_i_wis
jills125122823jil_ls
jilts124717413jil_ts
jimmie17376473jimmie
jimmies18328783jimmies
jinnis13489053jinnis
jisms14458003jism_s
kalmia1238893kalmia
kalmias1347973kalmias
kelims1278913kelims
kermis124012393kermis
kibbis14398473kibbis
kibeis12469803kibeis
kilim11711883kil_im
killie104114893killie
killies113318113killies
kills94526173kil_ls
kilns95112983kil_ns
kilos95021473kil_os
kiltie103210963kiltie
kilties113014143kilties
kilts95122183kil_ts
kiwis12328583ki_wis
koumis1237613koumis
leis45739603__leis
lichis115212593lichis
lilacs837483lilacs
lilies63021413lilies
lilos55821873lil_os
lilts55822803lil_ts
limas75627633li_mas
limbs96118943li_mbs
limes75636503li_mes
limit73126343li_mit
limits82514143li_mits
limns75718393li_mns
limos75320813li_mos
limps95522673li_mps
lis37162273__l_is
litmus836323litmus
malms95021553malm_s
midis85923413mi_dis
miladis1049813miladis
milds86422053mil_ds
milers84625163milers
miles74645073mil_es
milia72719573mil_ia
milks115020583mil_ks
milles84526563milles
mills75435053mil_ls
milos75428013mil_os
milpas101710273milpas
milreis937323milreis
mils66045333mil__s
milts75430713mil_ts
mimes95732023mi_mes
mimic111414323mi_mic
mimics1289363mi_mics
minims104514813minims
minis75432993mi_nis
miosis83615163miosis
mis58162623___mis
missis84417503missis
mitis75425993mi_tis
nilgais845193nilgais
nills54926673nil_ls
nils46132453nil__s
nims66226883ni_m_s
niseis63512023niseis
oilers64721193oilers
oilman839483oilman
oilmen848313oilmen
oils46337973oil__s
palais8420423palais
palmist112814343palmist
palms94921753palm_s
pelvis113610323pelvis
pigmies122610993pigmies
pikis115116393pi_kis
pilafs113511023pilafs
pilaus84114133pilaus
pilaws11399433pilaws
pilei74021783pilei_
piles74742613pil_es
pileus84514943pileus
pili66130353pil_i_
pills74130973pil_ls
pilots84018873pilots
pilous84717753pilous
pilus75921063pil_us
pimas94725103pi_mas
pimps114616983pi_mps
poleis86018353poleis
polis74731163pol_is
pulis74225603pul_is
refilms12347503refilm_s
riles55343643ril_es
rilles64725503rilles
rills55032713ril_ls
rimes75634543ri_mes
rims65936303ri_m_s
rishis9312453rishis
salamis9313513salamis
salmi7815863salmi_
semis74623533_semis
sigmas94111353sigmas
silds65520523sil_ds
silkie103313403silkie
silkies113715693silkies
silks94620683sil_ks
sillies73425073sillies
sills55135983sil_ls
silos56029423sil_os
silts55330823sil_ts
silvas92912183silvas
silvics1235563silvics
simas75727553si_mas
simlin8311733simlin
simlins9311833simlins
simps94719763si_mps
sims65737173si_m_s
sixmos1534813sixmos
slimes84722043slimes
slims75423653slim_s
swamis114212293swamis
sylis84316023syl_is
tallis63319963tallis
tamis76728723_tamis
tikis95615973ti_kis
tilaks1097353tilaks
tildes74513963tildes
tilers63523493tilers
tiles55542103til_es
tills54631703til_ls
tils45739613til__s
tilths9459373tilths
tilts55325613til_ts
times75630823ti_mes
timid84815723ti_mid
tipis76019923ti_pis
titis56023813ti_tis
umamis1038273umamis
vermis114214963vermis
villas96117263villas
villi86517853villi_
vills86429323vil_ls
villus93611223villus
vims95423313vi_m_s
wildish1446853wildish
wilds94818203wil_ds
wiles85437873wil_es
willie94116453willie
willies103920153willies
wills84528963wil_ls
wilts85023503wil_ts
wimmin1336153wimmin
wimps125213803wi_mps
yills83921553yil_ls
zills144020783zil_ls
zitis145815583zi_tis

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127164965.84319290.8
3Display Results4964960.1563179.5
 (SQL Overall)1786914966.12229188.3
 
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.