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

423 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
filmier123750(None) 
filmer114112401film_er
balmier113811512balmier
bilgier10358532bilgier
elmier839812_elmier
fierier103511192fierier
filcher15377792filcher
filer85433002fil__er
filler94623622fil_ler
fillies103420252fillies
filmed124610362film_ed
filmers124211292film_ers
filmgoer1442012filmgoer
filmi105914002filmi__
filmic13348452filmi_c
filmiest1338552filmiest
filmily1535732filmily
filming133210352filming
filmis114610282filmi_s
filmset1257512filmset
filter94517632fil_ter
filthier1434072filthier
finnier10319952finnier
firmer114712442firm_er
firrier103410132firrier
fishier13359852fishier
fizzier18326712fizzier
flamier123112142flamier
flier86023402f_l_ier
flimsier1344132flimsier
foamier12339002foamier
folkier14359042folkier
frillier1136512frillier
fumier11310902f_umier
hillier103413962hillier
limier83518722li_mier
malmier113611952malmier
milkier133411162milkier
millier93716702millier
miltier93214962miltier
oilier64417232oil_ier
palmier113312172palmier
rimier83916272ri_mier
silkier114411642silkier
sillier74017592sillier
siltier73413862siltier
slimier93212012slimier
wilier93217072wil_ier
aimer75926823ai_m_er
airier64619363ai_rier
almner85710723_almner
balkier134111983balkier
barmier114313043barmier
beamier113411943beamier
belier84423563bel_ier
bilayer12347803bilayer
bilbies114712343bilbies
bilker124913443bil_ker
biller84923483bil_ler
billie85019173billie_
billies93923503billies
bitsier9379073bitsier
bittier94211663bittier
boomier113312183boomier
bulgier103911213bulgier
bulkier134111513bulkier
bullier94116433bullier
calmer105216933calm_er
chillier13328423chillier
climber13449133climber
collier93618153collier
dallier84215373dallier
dicier94416233di_cier
dickier143512453dickier
dictier103411863dictier
dilater83515653dilater
dillies84122163dillies
diluter8319663diluter
dimer85625603di_m_er
dimmer114112613di_mmer
dingier93513673dingier
dinkier123411503dinkier
dippier123111393dippier
dirtier83312093dirtier
dishier113613403dishier
ditsier83010293ditsier
ditzier17307963ditzier
dizzier16317543dizzier
doomier103610123doomier
eelier64216463eel_ier
faddier1237783faddier
faggier12309843faggier
faller94621233fal_ler
falser93912413fal_ser
falsie93513853falsie_
falsies103515013falsies
falter94519053fal_ter
fancier123412063fancier
farmer115017373farm_er
farrier103514893farrier
fattier103513463fattier
faultier1135283faultier
fawnier13296363fawnier
feistier1136193feistier
feller94419553fel_ler
fellies104119743fellies
fennier10339253fennier
fernier103110823fernier
fibber134811933fi_bber
fiber104921133fi__ber
fibster12146533fibster
fickler16348423fickler
fiddler12309953fiddler
fielder11217413fielder
fiercer12356953fiercer
fifer115519973fi__fer
fifties132111083fifties
fighter143010773fighter
figurer11215863figurer
filar84819293fil__ar
filaree10611213filaree
filbert12411643fil_bert
filched16307423filched
filchers16286863filchers
filches153410723filches
file75446643fil__e_
filed95331903fil__ed
filers94623723fil__ers
files85441273fil__es
filet85540163fil__et
fileted1159093fileted
filial93013253fil_ial
filibeg1353383filibeg
filing103823763fil_ing
filister1137403filister
fille84327403fil_le_
filled104922263fil_led
fillers104320213fil_lers
filles94224523fil_les
fillet95027083fil_let
filling113520803filling
fillip11268953filli_p
filliped1435223filliped
fillips12298133fillips
fillister1244423fillister
film94828173film___
filmcard1642823filmcard
filmdom1562943filmdom
filmgoers1541983filmgoers
filminess1435983filminess
filmless1344553filmless
filmlike1734443filmlike
filmmaker2042373filmmaker
films105617963film__s
filmsets1353413filmsets
filmy136114043film__y
filose96112503filose_
filterer11258143filterer
filters103816553fil_ters
finder104020233fi_nder
finer85431563fi__ner
finger104920333fi_nger
firer811229253fi__rer
firmed125411883firm_ed
firmers124711443firm_ers
firming132811223firming
fisher124917143fi_sher
fitter94120033fi_tter
fiver116024943fi__ver
fixer154717833fi__xer
fizzer17369383fi_zzer
flair86114123f_lai_r
flaker134916173f_laker
flakier143910203flakier
flamer114919123f_lamer
flawier13378733flawier
flaxier17337983flaxier
flayer124713563f_layer
fleer86020773f_l_eer
flicker163610623flicker
flied96519433f_l_ied
fliers94417193f_l_iers
flies85630713f_l_ies
flimsies1335783flimsies
flinder11319873flinder
flinger113710513flinger
flintier1136393flintier
flipper14389143flipper
flir76422203f_l_i_r
flirter10318673flirter
flirtier1144893flirtier
flitter103413903flitter
flivver1633043flivver
flower124815503f_lower
flukier14397853flukier
fluter95316863f_luter
flutier103011553flutier
flyer114916253f_l_yer
flytier13356503flytier
foamer114714313foam_er
foggier12349913foggier
folder104317543fol_der
foliar93210973fol_iar
folkie13369613folkie_
folkies143612253folkies
folksier1533533folksier
follies103618943follies
footier104115113footier
forkier144311593forkier
former114221403form_er
foxier163910033f_oxier
fozier183710663f_ozier
framer114817443fram_er
frier85225843f__rier
friller104111743fril_ler
fringier1236553fringier
friskier1535193friskier
frizzier19284813frizzier
frumpier1534173frumpier
fubsier12367763fubsier
fuggier12348963fuggier
fuller94220383ful_ler
fulmar1137253fulm_ar
fulmine1257963fulmine
fulmined1454333fulmined
fulmines1357783fulmines
fumer105918233f_um_er
funkier14349983funkier
funnier103210173funnier
furrier103513663furrier
furzier19318103furzier
fusilier1135423fusil_ier
fussier103610673fussier
fustier104213933fustier
fuzzier18256523fuzzier
gamier93617933_gamier
gammier123711193gammier
gemmier12337383gemmier
germier10309543germier
giddier10308723giddier
gilder84415533gil_der
giller74519733gil_ler
gillie74816943gillie_
gillied95512313gillied
gillies84120963gillies
gimmie11298183gimmie_
gimmies123010113gimmies
gimpier12247943gimpier
ginnier8298983ginnier
girlier8289523girlier
glimmer12437713glimmer
gluier7310263_gluier
grimier103210433grimier
guiltier934493guiltier
gulfier1137793gulfier
gulpier1046953gulpier
gummier12349473gummier
hammier143510653hammier
haulmier1333143haulmier
hiller94421633hil_ler
hinkier143610793hinkier
hippier143212103hippier
hissier103410503hissier
holier94921623hol_ier
homier116416993_homier
hulkier14328973hulkier
icier74313753_i_cier
ickier12439923_ickier
iffier1236763_iffier
iller54821293_il_ler
immies102412443_immies
inkier104013783_inkier
inlier63615363_inlier
jammier18408023jammier
jiggier16377823jiggier
jilter133512513jil_ter
jimmie17376473jimmie_
jimmied19275033jimmied
jimmies18328783jimmies
jimper17389863ji_mper
jivier16438613ji_vier
jollier142911003jollier
joltier14318493joltier
kickier12349053kickier
killer104917953kil_ler
killie104114893killie_
killies113318113killies
kilter103714343kil_ter
kiltie103210963kiltie_
kilties113014143kilties
kinkier10319433kinkier
lier45942463__l_ier
lilied73913213lil_ied
lilies63021413lil_ies
limber104316793li_mber
limbier11349113limbier
limiter92710853li_miter
limmer104314793li_mmer
limner84112873li_mner
limper104117853li_mper
lingier84113383lingier
linier64423793li_nier
lintier73613803lintier
lippier112710573lippier
livier97514593li_vier
loamier9349163loamier
maltier93015483maltier
miffier1537023miffier
milder93818453mil_der
miler75733063mil__er
milieu8314113mil_ieu
milker124814323mil_ker
miller84625413mil_ler
milliers102611903milliers
milliner102811863milliner
milter84921233mil_ter
mimer94825763mi_m_er
mincier113512473mincier
mingier103815293mingier
mintier93615993mintier
mirier83918363mi_rier
mirkier13319053mirkier
mistier93418713mistier
mitier83620673mi_tier
moldier103110033moldier
niftier10328713niftier
nippier11319833nippier
nittier73512243nittier
oiler54628283oil__er
oilmen848313oilm_en
palier85023563pal_ier
pallier94417163pallier
palmer105816543palm_er
pickier153912973pickier
piggier113510003piggier
pigmies122610993pigmies
pilfer1139163pil_fer
pilsner935343pilsner
pinier84024693pi_nier
pipier104913983pi_pier
pismire1135353pismire
pithier123010293pithier
pitier84019823pi_tier
plier75221283_pl_ier
plumier113510043plumier
premier113515633premier
pulpier1148623pulpier
qualmier1934563qualmier
rallier73816273rallier
rammier112811023rammier
relier65826183rel_ier
ribbier1137593ribbier
ribier84414233ri_bier
ridgier937883ridgier
rimer75429243ri_m_er
rimmer103516033ri_mmer
riskier1138423riskier
ritzier16297203ritzier
roilier7311523roil_ier
roomier93812243roomier
rulier65016353rul_ier
rummier11309563rummier
sallier73320423sallier
saltier74318633saltier
seamier93114633seamier
silkie103313403silkie_
silkies113715693silkies
siller64026063sil_ler
sillies73425083sillies
silver93815813sil_ver
simmer104115353si_mmer
simper103616293si_mper
sissier73711363sissier
sizier1514813393si_zier
slier54827243_sl_ier
slimmer114211343slimmer
slimsier1085213slimsier
soldier82812153soldier
spumier1137903spumier
stillier868823stillier
sulkier113811963sulkier
swimmier15174313swimmier
talkier114011843talkier
tallier72817213tallier
thymier1534393thymier
tidier73515113ti_dier
tiler56131023til__er
tiller64222543til_ler
tilter63417693til_ter
timber104012683ti_mber
timer75626043ti_m_er
timider1037093ti_mider
tinier63622233ti_nier
tinnier72910143tinnier
tippier113210543tippier
tipsier9268893tipsier
uglier748953ugl_ier
viewier1334983viewier
viler86324163vil__er
vilifier1456693vilifier
vinier93716743vi_nier
vizier184311023vi_zier
wieldier1234283wieldier
wiftier13297733wiftier
wiggier12418863wiggier
wilder103616473wil_der
willer94021063wil_ler
willie94116453willie_
willied114611563willied
willies103920153willies
wimpier14248053wimpier
windier113412163windier
wingier113413283wingier
winier94522453wi_nier
wirier94215553wi_rier
wispier12249403wispier
withier132910493withier
wittier103910823wittier
wormier12278763wormier
yolkier14336123yolkier
yummier14306843yummier
zingier17369493zingier
zippier20308193zippier

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.406440125.6
2DLD Change Limit1340274236.11021935.7
3Display Results4234230.1562711.5
 (SQL Overall)1786914236.67226782.2
 
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.