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

249 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
fiercer1235695(None) 
fierce11348911fierce_
fierier103511191fierier
piercer11337771piercer
amercer1146372amercer
coercer1138382coercer
farcer115016082f_arcer
fencer114613532f_encer
fielder11217412fielder
fiercely1643312fiercely
fiercest13216142fiercest
firer811229252fi_r_er
firmer114712442fi_rmer
firrier103410132firrier
fleecer12368032fleecer
forcer114917342f_orcer
mercer105214202_mercer
piecer105213082pie_cer
pierce104010392pierce_
pierced12347592pierced
piercers12316722piercers
pierces113411192pierces
tierce8339842tierce_
tierced10347052tierced
tiercel9316202tiercel
tierces93710452tierces
acerber1135243acerber
aerier64823153_aerier
airer54927893ai_r_er
airier64619363ai_rier
alerter72111513alerter
amerce10310513amerce_
amerced1256523amerced
amercers1256133amercers
amerces1149853amerces
averter102410553averter
beerier93613023beerier
birder94915493bi_rder
birler85715083bi_rler
circler1136423ci_rcler
coerce10310403coerce_
coerced1238583coerced
coercers1237653coercers
coerces11311943coerces
deicer94114413_deicer
dicer85426423di__cer
diester83013683diester
dieter73516773die_ter
diether1147443diether
directer1137583directer
direr64927073di_r_er
diverter12238623diverter
divorcer1444033divorcer
eerier64320023_eerier
facer105525053f__acer
faeces114713123fae_ces
faerie93514683faerie_
faeries104118993faeries
faience1237513faience_
faiences1337043faiences
fairer95212063fair_er
farce104925323f_arce_
farced125216533f_arced
farcers124713443f_arcers
farces115223323f_arces
farceur12525273f_arceur
farer86733143f_ar_er
farmer115017373f_armer
farrier103514893farrier
fearer94820183f_earer
feater95224053f_eater
feces105625363f_e_ces
feebler1235823feebler
feeder103513843f_eeder
feeler93215173f_eeler
feigner1135593feigner
feirie939553feirie_
feller94419553f_eller
fence105319913f_ence_
fenced124412713f_enced
fencers123810623f_encers
fences114617113f_ences
fender103718723f_ender
fere76342233f_er_e_
feres86038183f_er_es
fernery1335813f_ernery
fernier103110823f_ernier
ferrel92810203f_errel
ferret93021173f_erret
fervor1235643f_ervor
fester94723513f_ester
fetcher153510393f_etcher
fetter94120383f_etter
fever115617953f_e_ver
fewer115216123f_e_wer
feyer115014523f_e_yer
fiacre1137623fiacre_
fiacres1237253fiacres
fiance11310743fiance_
fiancee1238953fiancee
fiances12310673fiances
fibber134811933fi_bber
fiber104921133fi__ber
fibered1337643fiber_ed
fibre104812843fibr_e_
fibres114312123fibr_es
fibster12146533fibster
fice95737113fi__ce_
fices106031163fi__ces
fickler16348423fickler
fiddler12309953fiddler
fielded12206813fielded
fielders12156773fielders
fieriest112112243fieriest
fierily1339023fierily
fiery114714793fier__y
fifer115519973fi__fer
figeater1236953figeater
fighter143010773fighter
figurer11215863figurer
filcher15377793filcher
filer85433003fi__ler
filler94623623fi_ller
filmer114112403fi_lmer
filmier1237503filmier
filter94517633fi_lter
filterer11258143filter_er
finder104020233fi_nder
finer85431563fi__ner
fineries112416743fineries
finger104920333fi_nger
fingerer12127223finger_er
finnier10319953finnier
fire76245593fi_r_e_
fired94829743fi_r_ed
firemen1238773firemen
firers94922683fi_r_ers
fires85740753fi_r_es
firmed125411883fi_rmed
firmers124711443fi_rmers
fisher124917143fi_sher
fishier13359853fishier
fitter94120033fi_tter
fiver116024943fi__ver
fixer154717833fi__xer
fizzer17369383fi_zzer
fizzier18326713fizzier
fleece11369903fleece_
fleeced13358153fleeced
fleecers13325933fleecers
fleeces12399643fleeces
fleecier1334763fleecier
fleer86020773fle__er
fleeter103210363fleeter
flenser1036783flenser
flesher133610923flesher
fletcher16306663fletcher
flirter10318673flirter
force105324273f_orce_
forced126316523f_orced
forcers124215713f_orcers
forces114422133f_orces
forever1338953forever
forger104820773f_orger
forker134717903f_orker
former114221403f_ormer
freer86021243f__reer
freezer19348523freezer
frere85617723frer_e_
freres94716173frer_es
frescoer1345983frescoer
fresher132612643fresher
fretter103412753fretter
frier85225843f__rier
fryer115913433f__ryer
fuehrer1332973fuehrer
fueler94313933fue_ler
fueller10279963fueller
fuhrer1235033fuhr_er
furler93616403f_urler
furrier103513663furrier
girder84312063gi_rder
herder104516463_herder
hirer85423123hi_r_er
jeerer13389933jeer_er
jerker17369043_jerker
kiester11329973kiester
leerier73111503leerier
licencer12146133licencer
lieder74912323lie_der
liefer9529573lie_fer
lierne638023lierne_
liernes739623liernes
liever94611863lie_ver
mercers114412773_mercers
mercery14397623_mercery
merces105720743_merces
merer75126233_mer_er
merger95016483_merger
mincer104017363mi_ncer
mirier83918363mi_rier
mirker123712693mi_rker
miterer92511333miter_er
nicer74618293ni__cer
niece74814503nie_ce_
nieces84112713nie_ces
offerer1335543offer_er
onerier7311613onerier
percher143313423_percher
perter84422283_perter
piece96717993pie_ce_
pieced113912103pie_ced
piecers114112253pie_cers
pieces104217273pie_ces
pincer104019173pi_ncer
querier16310013querier
ricer74726613ri__cer
ricercar1263333ricercar
riever94811653rie_ver
scarcer113911373scarcer
serer55935513_ser_er
serger73819743_serger
server94917713_server
silencer1036293silencer
spencer113610973spencer
sterner7411913sterner
swerver1365733swerver
terce75721843_terce_
tercel83612993_tercel
terces83921413_terces
tercet83624913_tercet
termer85717253_termer
terser67317823_terser
tiercels10344733tiercels
tierceron1152223tierceron
tiered73613973tier_ed
tireder837703tireder
verger104315703_verger
verier94620963_verier
verser94516963_verser
viewer1237213vie_wer
viewier1334983viewier
weirder1144923weirder
wielder11197673wielder
wiener94513543wie_ner
wincer115018193wi_ncer
wirer85124953wi_r_er
wirier94215553wi_rier
yielder11175113yielder

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.423422437.4
2DLD Change Limit1340272496.00022337.8
3Display Results2492490.0763276.3
 (SQL Overall)1786912496.49927495.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.