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

196 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
frier8522584(None) 
brier74527401brier
crier74724461crier
drier64423961drier
firer811229251firer
flier86023401flier
freer86021241freer
friar85414271friar
fried95322911fried
friers94718931friers
fries85535601fries
frizer184011281frizer
fryer115913431fryer
prier75027761prier
trier54328531trier
wrier84521751wrier
aerier64823152aerier
airer54927892airer
airier64619362airier
arider74717742arider
ariel55228972ariel
armer76924442armer
artier63419732artier
bier65531832_bier
briar75718152briar
briber104714052briber
brie65837902brie_
brief105422602brief
briers85319732briers
briery114510772briery
bries74942152bries
briner84519042briner
burier84324652burier
cried84624282cried
criers83918582criers
cries75438402cries
direr64927072direr
dried75321382dried
driers74516732driers
dries64733672dries
driver104714492driver
dryer95111462dryer
eerier64320022eerier
facer105525052facer
fader94421512fader
fainer94717242fainer
fair76332522fai_r
fairer95212062fairer
faker124824592faker
farcer115016082farcer
farer86733142farer
farmer115017372farmer
farrier103514892farrier
fer66646122f__er
fernier103110822fernier
fever115617952fever
fewer115216122fewer
feyer115014522feyer
fiar76427332f_iar
fiber104921132fiber
fie67152442f_ie_
fief107331362f_ief
fierier103511192fierier
fiery114714792f_iery
fifer115519972fifer
filer85433002filer
finer85431562finer
fir66744892f_i_r
fire76245592fire_
fired94829742fired
firers94922682firers
fires85740752fires
firmer114712442firmer
firrier103410132firrier
fiver116024942fiver
fixer154717832fixer
fleer86020772fleer
flied96519432flied
fliers94417192fliers
flies85630712flies
flir76422202fli_r
flyer114916252flyer
forcer114917342forcer
forger104820772forger
forker134717902forker
forkier144311592forkier
former114221402former
foxier163910032foxier
foyer116416552foyer
fozier183710662fozier
frae75330472frae_
frailer10319942frailer
framer114817442framer
frater94520592frater
free75940182fr_ee
freed95223542freed
freers94717302freers
frees86131392frees
frere85617722fr_ere
fret75845042fr_et
friars93812092friars
friary124010092friary
friend10388932friend
frieze18378142frieze
frig85424502fri_g
friges104116482friges
frigs96019272frigs
frill84917562frill
friller104111742friller
frise85322452frise
frisee94217992frisee
frises94124272frises
friseur1033672friseur
frisk125312372frisk
frisker14389272frisker
frit77044472fri_t
frites94922482frites
frith115922032frith
frits86129102frits
fritt86129412fritt
fritter103912772fritter
fritz176020772fritz
friz166324342fri_z
frized193510682frized
frizers19329552frizers
frizes184015462frizes
frizz165512622frizz
frizzer18446892frizzer
froe75329992froe_
froes86126692froes
frore86218802frore
fruiter10309682fruiter
fryers125710972fryers
fumer105918232fumer
fumier11310902fumier
furies95126372furies
furler93616402furler
furrier103513662furrier
furzier19318102furzier
gorier73719372gorier
grief95319782grief
griper94114612griper
hirer85423122hirer
icier74313752icier
iffier1236762iffier
kier86526812_kier
lier45942462_lier
mirier83918362mirier
orbier839992orbier
order65019362order
oriel54920422oriel
ormer75218372ormer
osier53518012osier
pier66035292_pier
plier75221282plier
pricer103918292pricer
pried84426862pried
priers84521192priers
pries74339532pries
primer105118682primer
prior74316172prior
prizer174714882prizer
pryer104415312pryer
ricer74726612_ricer
rider65231302_rider
riel46432382_riel
rifer84721982_rifer
rimer75429242_rimer
riper74328402_riper
riser55431052_riser
river85731692_river
ruer46127562_ruer
shier85428942shier
skier95119592skier
slier54827242slier
spier75728032spier
sprier84119062sprier
tier44936142_tier
tried65026912tried
triers64321522triers
tries55742812tries
trimer85717152trimer
triter65120592triter
truer54916642truer
twier84713292twier
urger64116472urger
varier94619352varier
verier94620962verier
vier75428152_vier
warier93722892warier
wirer85124952wirer
wirier94215552wirier
wried95518562wried
wries85827742wries
writer94416512writer
wryer11489302wryer

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001961.40638264.6
3Display Results1961960.0464260.9
 (SQL Overall)1786911961.765101241.4
 
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.