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

548 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
fernier10311082(None) 
dernier83011941dernier
fennier10339251fennier
vernier102711271vernier
aerier64823152aer_ier
barnier93213672barnier
cornier93017092cornier
denier74420692de_nier
eerier64320022eer_ier
farrier103514892farrier
fawnier13296362fawnier
fencer114613532fe_ncer
fender103718722fe_nder
ferine96422582ferine_
ferlie92814052ferlie_
ferlies103216692ferlies
fernery1335812fern_ery
ferniest1132214152ferniest
ferried113411522ferried
ferries103521082ferries
fierier103511192fier_ier
finnier10319952finnier
firrier103410132firrier
forkier144311592forkier
frier85225842f_r_ier
funnier103210172funnier
furrier103513662furrier
furzier19318102furzier
germier10309542germier
herbier1239592herbier
hornier103012462hornier
jerkier18407272jerkier
merrier92612302merrier
nerdier83110352nerdier
nervier10298832nervier
perkier133813122perkier
pornier93413132pornier
teenier72611142teenier
terrier73414962terrier
veinier10269582veinier
verier94620962ver_ier
verniers11227842verniers
weenier103210802weenier
wennier10318602wennier
aerie54634603aer_ie_
aeried74221863aer_ied
aeries64737783aer_ies
airier64619363air_ier
artier63419733_artier
barkier133814483barkier
barmier114313043barmier
barrier94017733barrier
beadier103513913beadier
beakier134012163beakier
beamier113411943beamier
beanie83618593beanie_
beanies93821093beanies
beefier12329093beefier
beerier93613023beerier
belier84423563be_lier
bender95223303be_nder
bendier103111413bendier
bennies93917313bennies
berried103714043berried
berries94423553berries
bonier84321993_bonier
bonnier94711313bonnier
brevier1237763brevier
brier74527403_br_ier
briner84519043_briner
brinier93613473brinier
burier84324653bur_ier
burlier93514413burlier
burner83819203burn_er
burnie83715413burnie_
burnies94017823burnies
burrier93613553burrier
byrnie11348573byrnie_
byrnies12378573byrnies
cannier94014163cannier
carnie84421093carnie_
carnies94123963carnies
carrier93619583carrier
censer84516583ce_nser
center84421413ce_nter
chertier1387873chertier
corkier133114303corkier
corner84625623corn_er
crepier1139733crepier
crier74724463_cr_ier
curdier103312623curdier
curlier93314183curlier
currier93316703currier
curvier123110663curvier
darner74017303darn_er
decrier102713553decrier
deedier93011593deedier
defier105118653de_fier
definer114413773definer
deifier113013123deifier
denied84318633de_nied
deniers84515183de_niers
denies74729643de_nies
denser74115193de_nser
deranger1037353deranger
derbies103016053derbies
derider93214973derider
deringer1038143deringer
deriver114213913deriver
derriere936043derriere
derries83124623derries
dewier104013463de_wier
dirtier83312093dirtier
dorkier122810023dorkier
downier11299703downier
drier64423963_dr_ier
earlier72612743earlier
earner63617223earn_er
easier64218463_easier
edgier8469723_edgier
eelier64216463_eelier
eerie55228533eer_ie_
elmier839813_elmier
ender64325863_e_nder
enter54726383_e_nter
envier939673_envier
eraser64216333_eraser
erne46727423_ern_e_
ernes55224813_ern_es
faddier1237783faddier
faerie93514683faer_ie_
faeries104118993faer_ies
faggier12309843faggier
fainer94717243fain_er
fainter103611053fainter
fancier123412063fancier
fanner94218183f_anner
fannies103415643fannies
farcer115016083far_cer
farcie114816473farcie_
farcies125317883farcies
farer86733143far__er
farmer115017373far_mer
farriers113610743farriers
farriery14295403farriery
farther1348343farther
fattier103513463fattier
fawner125910463fawn_er
fearer94820183fe_arer
feaster10812983feaster
feater95224053fe_ater
feather133613503feather
featlier1136453featlier
feebler1235823feebler
feeder103513843fe_eder
feeler93215173fe_eler
feigner1135593feigner
feinted11379623feinted
feirie939553feirie_
feistier1136193feistier
feline94820143feline_
felines104718073felines
feller94419553fe_ller
fellies104119743fellies
felonies11310993felonies
feminie12179933feminie_
fence105319913fe_nce_
fenced124412713fe_nced
fencers123810623fe_ncers
fences114617113fe_nces
fended114216913fe_nded
fenders113717263fe_nders
fennec11326913fe_nnec
fennel9429473fe_nnel
fenniest113113203fenniest
feoffer1233023feoffer
fere76342233fer__e_
feres86038183fer__es
feria85922713fer_i_a
feriae95618603fer_iae
ferial94621253fer_ial
ferias95020393fer_ias
ferities111416713ferities
ferity122813343fer_ity
fermenter1497543fermenter
fermi103914163fermi__
fermion1236763fermion
fermis114313503fermi_s
fermium1446353fermium
fern76129323fern___
ferneries1239043ferneries
ferninst11238313ferninst
fernless1136063fernless
fernlike1535243fernlike
ferns85220083fern__s
ferny115816183fern__y
ferrel92810203fer_rel
ferret93021173fer_ret
ferreter1136543ferreter
ferric1139993ferri_c
ferrite103312753ferrite
ferrites112312833ferrites
fertile10311733fertile
ferule93413203ferule_
feruled11318413feruled
ferules103112723ferules
fervid1337513fervi_d
fervor1235643fer_vor
fervour1343103fervour
fester94723513fe_ster
fetcher153510393fetcher
fetter94120383fe_tter
fever115617953fe__ver
fewer115216123fe__wer
feyer115014523fe__yer
fiercer12356953fier_cer
filmier1237503filmier
finder104020233f_inder
finer85431563f_in_er
finger104920333f_inger
firer811229253fir__er
firmer114712443fir_mer
fishier13359853fishier
fizzier18326713fizzier
flakier143910203flakier
flamier123112143flamier
flanger113412623flanger
flanker143911293flanker
flawier13378733flawier
flaxier17337983flaxier
fledgier1333683fledgier
fleecier1334763fleecier
flenser1036783flenser
fleshier1435603fleshier
flier86023403f__lier
flinder11319873flinder
flinger113710513flinger
flintier1136393flintier
flirtier1144893flirtier
flukier14397853flukier
flunker14389363flunker
flutier103011553flutier
flytier13356503flytier
foamier12339003foamier
foggier12349913foggier
folkier14359043folkier
fonder104120063f_onder
footier104115113footier
forager114412563forager
forayer13368953forayer
forcer114917343for_cer
forever1338953forever
forger104820773for_ger
forgiver1534183forgiver
forgoer1137693forgoer
forker134717903for_ker
former114221403for_mer
fornices1369103fornices
fornix1636033forni_x
forties104323863forties
founder114312573founder
foxier163910033f_oxier
fozier183710663f_ozier
frailer10319943f_railer
framer114817443f_ramer
franker143510183franker
frater94520593f_rater
freakier15246483freakier
freer86021243f_r_eer
freezer19348523freezer
frenzied2144043frenzied
frenzies2037713frenzies
fresher132612643fresher
fretter103412753fretter
frettier1156593frettier
friar85414273f_r_iar
fried95322913f_r_ied
friers94718933f_r_iers
fries85535603f_r_ies
fringier1236553fringier
frizer184011283f_rizer
fronter103611583fronter
frontier1147313frontier
fruiter10309683f_ruiter
fryer115913433f_r_yer
fubsier12367763fubsier
fuggier12348963fuggier
fumier11310903f_umier
funder104016083f_under
funker133915763f_unker
funkier14349983funkier
funner93414103f_unner
funnies104113603funnies
furies95126373fur_ies
furler93616403fur_ler
furnish1337383furnish
furnisher1544523furnisher
furriers11369493furriers
furriery14395683furriery
furriner11267303furriner
further1337003further
fussier103610673fussier
fustier104213933fustier
fuzzier18256523fuzzier
garner73917003garn_er
geekier12286393geekier
gemmier12337383gemmier
gender83517933ge_nder
genie66124923ge_nie_
genies75324943ge_nies
ginnier8298983ginnier
girlier8289523girlier
goonier83612843goonier
gorier73719373gor_ier
gorsier83811073gorsier
greenier938713greenier
hardier114721543hardier
harrier104417753harrier
headier113212953headier
heartier1139093heartier
heavier13429423heavier
hedgier12367873hedgier
heftier1337203heftier
heinie92512663heinie_
heinies102514543heinies
hempier14319003hempier
henries102718283henries
herder104516463her_der
hernia9312293herni_a
herniae1039043herniae
hernial10310433hernial
hernias10310773hernias
herried113514453herried
herries104025073herries
horsier103013243horsier
hurrier103412943hurrier
jennies143511623jennies
jerker17369043jer_ker
jerkies183411583jerkies
jerries143817513jerries
jettier14358693jettier
keener104012833keen_er
kerne94718213kern_e_
kerned114112923kern_ed
kernel104010583kern_el
kernes104717523kern_es
kerning124010893kerning
kernite1159473kernite
kernites1269113kernites
kerries113317913kerries
lardier83518343lardier
larkier113711523larkier
leadier83212723leadier
leafier10329833leafier
leakier114010993leakier
leaner64022193lean_er
learier73415663learier
learner7319383learn_er
leavier10319993leavier
ledgier9458493ledgier
leerier73111503leerier
leggier9368233leggier
lender73921273le_nder
levier94013873le_vier
linier64423793_linier
loonier73312683loonier
loriner7511893loriner
lunier64617603_lunier
mariner93315993mariner
marlier92614773marlier
marrier93817523marrier
mealier93015903mealier
meander1049973meander
meaner84617843mean_er
meanie83718393meanie_
meanies93620743meanies
meatier93214613meatier
meinie82614523meinie_
meinies92516073meinies
mender93520793me_nder
mercer105214203mer_cer
mercies113817563mercies
merer75126233mer__er
merger95016473mer_ger
meshier123410853meshier
messier93412923messier
metier83517693me_tier
meuniere1043233meuniere
mirier83918363mir_ier
mirkier13319053mirkier
moonier93714103moonier
murkier133110273murkier
nearlier836793nearlier
needier84010623needier
nettier74211813nettier
newsier10147223newsier
onerier7311613oner_ier
orbier839993_orbier
panier84425503_panier
pannier93613353pannier
parrier93717653parrier
partier93520713partier
peakier134411443peakier
pearlier1037323pearlier
peatier94017233peatier
peckier153910523peckier
penner84616663pe_nner
pennies94218813pennies
peonies93620153peonies
peppier10268323peppier
percher143313423percher
perdie94718513perdie_
perinea9313033perinea
pernio8513143perni_o
perries93226603perries
perter84422283per_ter
peruser93511373peruser
peskier13319113peskier
pestier94317403pestier
pettier94213613pettier
phonier122710633phonier
pinier84024693_pinier
porkier133712343porkier
premier113515633premier
prier75027763_pr_ier
punier84519223_punier
punnier93511263punnier
pursier94012753pursier
purtier93214093purtier
querier16310013quer_ier
rainier71614263rainier
readier83117423readier
reedier83815303reedier
reefier102912553reefier
reekier113111123reekier
reenter73217793reenter
refiner105316913refiner
reifier103414523reifier
reinter73116843reinter
relier65826183re_lier
render74024143re_nder
renter64527413re_nter
rentier73618223rentier
repiner94816903repiner
replier94214973replier
reuniter838323reuniter
runnier74010113runnier
sarkier113413313sarkier
seamier93114633seamier
sedgier9399043sedgier
seedier83513633seedier
seepier92912013seepier
seiner64622483sein_er
sender73824413se_nder
senior63214043se_nior
serener73415753serener
serer55935503ser__er
serger73819733ser_ger
series64540973ser_ies
serine65432673serine_
serines74229543serines
serried82513963serried
serries73925353serries
server94917713ser_ver
servicer1335263servicer
sexier13310683se_xier
sheenier11167423sheenier
shinier104113143shinier
sorner64720393sorn_er
sorrier72313733sorrier
spinier93715163spinier
sprier84119063spr_ier
sterner7411913stern_er
stonier72013793stonier
sunnier73412153sunnier
surfier102613543surfier
surlier72915443surlier
tardier859719993tardier
tarrier74323173tarrier
tarsier74119253tarsier
tartier74123263tartier
tawnier10318463tawnier
tearier73815613tearier
techier1269243techier
teener64717503teen_er
teensier835573teensier
tender74121843te_nder
tenner64117103te_nner
tennies73017973tennies
tenser64919433te_nser
tenter64623933te_nter
tentier73815923tentier
termer85717253ter_mer
terne56426153tern_e_
ternes65422903tern_es
ternion739493ternion
terriers84210823terriers
terries73425633terries
terser67317823ter_ser
testier74015643testier
thornier1135323thornier
tinier63622233_tinier
tinnier72910143tinnier
tonier65520713_tonier
trendier937913trendier
trier54328533_tr_ier
turfier10249793turfier
turner63914613turn_er
twinier1037313twinier
varier94619353var_ier
vealier102712173vealier
veiner94514753vein_er
vender103418423ve_nder
veneer94511693ve_neer
venire93513693ve_nire
venter94218723ve_nter
verditer1236223verditer
verger104315693ver_ger
verifier14159203verifier
vernix1636633verni_x
vernixes1836053vernixes
verser94516963ver_ser
vinier93716743_vinier
wanier93920683_wanier
warier93722893war_ier
warner93717223warn_er
wartier103413913wartier
weaner93816773wean_er
wearier103613283wearier
webbier1445423webbier
wedgier12428273wedgier
weedier113810623weedier
weenie92612023weenie_
weenies102915093weenies
weensier1134243weensier
weepier12319273weepier
weiner94214133wein_er
whinier134110633whinier
winier94522453_winier
wirier94215553wir_ier
wordier112511213wordier
wormier12278763wormier
worrier102311683worrier
wrier84521753_wr_ier
yarner93313063yarn_er
yearner10336873yearn_er
zanier154314713_zanier
zestier163010223zestier

Search took 8 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.1561145455.1
2DLD Change Limit1340275486.87619492.0
3Display Results5485480.1862946.2
 (SQL Overall)1786915487.21824756.3
 
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.