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

243 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
fighters1526940(None) 
fighter143010771fighter_
lighters123111391lighters
righters122610711righters
sighters122510601sighters
blighters1555742blighters
fagoters1234862fagoters
fibsters13126412fibsters
fidgeters1443622fidgeters
figeaters1345752figeaters
fights133816552fight__s
figurers12254872figurers
filters103816552fi_lters
fishers134714722fish_ers
fitters104517752fi_tters
flichters1774172flichters
freighters1764122freighters
frightens1655392frightens
infighters1743322infighters
lightens122510002lightens
lighter113113442lighter_
plighters1545532plighters
righter113212382righter_
sighers113712182sigh_ers
sighter113412112sighter_
slighters1346712slighters
tightens12297952tightens
tighter112910692tighter_
weighters1644672weighters
bighted142810923bighte_d
bights124417963bight__s
bisters93922613bi_sters
biters83925243bi__ters
bitters94920363bi_tters
blighter1466853blighter_
brightens1565373brightens
brighter1476663brighter_
ciphers14379993ciph_ers
citers85022983ci__ters
cithers124315773cith_ers
daughters1443993daughters
delighters1544363delighters
diasters92913183diasters
diesters92513603diesters
dieters83216433di_eters
diethers1257453diethers
digesters11257883digesters
diggers104413393dig_gers
dighted132511493dighte_d
dights114016963dight__s
dilaters92513063dilaters
diluters9288113diluters
dimeters11411093dimeters
diopters1137693diopters
dithers114016153dith_ers
eighteen1245763eighteen
eighteens1344883eighteens
eighths14388293eight_hs
eighties12710803eighties
eights103618983eight__s
eightvos1543743eightvos
fagoter1135883fagoter_
fainters11349693fainters
falters103916473f_alters
fathers133916503fath_ers
feasters11511563feasters
feathers143513243feathers
feigners1235483feig_ners
festers104121393f_esters
fetters103517903f_etters
fibbers144510603fi_bbers
fibers114717523fi__bers
fibster12146533fibster_
fiches145219533fich_e_s
fiddlers13328283fiddlers
fidgeter1343783fidgeter_
fielders12156773fielders
fifers125414923fi__fers
figeater1236953figeater_
fight124027093fight___
fighting162710083fighting
fightings17276503fightings
figurer11215863figurer_
figures11239113figure_s
filchers16286863filchers
filers94623723fi__lers
filisters1237003filisters
fillers104320213fi_llers
filmers124211293fi_lmers
filter94517633fi_lter_
finders113717873fi_nders
fingerers13136303fingerers
fingers113418433fi_ngers
finites10315923finite_s
firers94922683fi__rers
firmers124711443fi_rmers
fisher124917143fish_er_
fishery16397733fish_ery
fishes125221343fish_e_s
fishier13359853fishier_
fishless1436413fishless
fishnets1445633fishnets
fitter94120033fi_tter_
fivers124420923fi__vers
fixates1737393fixate_s
fixers165112983fi__xers
fizzers18357003fi_zzers
flatters113814203flatters
flichter1664963flichter_
flighted1646973flighte_d
flightier1644423flightier_
flightless1773393flightless
flights143310983flight__s
flirters11337933flirters
flitters114312173flitters
floaters112711513floaters
flouters11419273flouters
flusters113811503flusters
fluters103713683f_luters
flutters114010823flutters
foggers124112013fog_gers
footers104618333f_ooters
fosters104220103f_osters
fraters103517213f_raters
freighter1655023freighter_
fretters113410303fretters
frigates12310933frigate_s
frighted1657173frighte_d
frighten1566443frighte_n
frights14339623fright__s
fritters113810783fritters
frothers14279813frothers
fruiters11328183fruiters
fuehrers1442613fuehrers
fuhrers1334813f_uhrers
furthers1436493furthers
gagsters10317083gagsters
gaters74728643__gaters
gigglers11297403gigglers
gunfighters1951373gunfighters
heightens1644713heightens
higglers13297233higglers
higher134610893high_er_
highness1536053highness
highted152710163highte_d
highths13358003hight_hs
hightops1745043hightops
hights133716893hight__s
hinters103719583hi_nters
hipsters13268793hipsters
hitters104717593hi_tters
igniters9126233_igniters
infighter1644273infighter_
inters64328053_i_nters
jiggers164010183jig_gers
jilters144211963ji_lters
jitters144314473ji_tters
kiesters123310153kiesters
kilters113813603ki_lters
kiters105218593ki__ters
laughters1344593laughters
lifters104313783li_fters
ligates82318383ligate_s
ligers75022043lig__ers
lighted122913503lighte_d
lighten112811523lighte_n
lighteners1444983lighteners
lightered1446283lightered
lightest121410353lightest
lightless1386073lightless
lightness13107433lightness
lights104519913light__s
limiters10249333limiters
linters73822633li_nters
listers74026533li_sters
liters65429883li__ters
litters73422573li_tters
mightier1436383mightier_
mights123516253might__s
milters93619093mi_lters
minsters103813923minsters
minters93822473mi_nters
misters93927513mi_sters
miters84328783mi__ters
mithers123516733mith_ers
negaters9349783negaters
niggers93111323nig_gers
nigglers10307253nigglers
nigher103612753nigh_er_
nighness1236103nighness
nighties121011383nighties
nightjars2043343nightjars
nightless1386073nightless
nights104117723night__s
niters64624213ni__ters
piasters102912813piasters
pishers123815753pish_ers
plighter1476623plighter_
riggers93613843rig_gers
righted122912143righte_d
righteous1345073righteous
rightest12149583rightest
righties12711573righties
rightness13117353rightness
rights104019333right__s
rioters73615523ri_oters
ritters74020623ri_tters
riveters11228163riveters
sifters103714793si_fters
sigher103813703sigh_er_
sighless1276553sighless
sighted123111523sighte_d
sightless1385923sightless
sights103818013sight__s
sightseers1452543sightseers
sightsees1344543sightsees
signers84714443sig_ners
sinters74024083si_nters
sisters73721593si_sters
sitters74221553si_tters
slighter1257823slighter_
tigers75616513tig__ers
tighten11288973tighte_n
tighteners1444043tighteners
tightest12148363tightest
tightness1386603tightness
tights104015853tight__s
tilters73315953ti_lters
tinters74221113ti_nters
tipsters10278523tipsters
titers64526413ti__ters
tithers104216733tith_ers
titters74219623ti_tters
visiters1137413visiters
weighers15135673weigh_ers
weighter1535603weighter_
wigglers13257213wigglers
wights133315783wight__s
winters103720483wi_nters
wishers133215213wish_ers
withers134417753with_ers
yachters1633883yachters
zithers193911973zith_ers

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622437.19020328.5
3Display Results2432430.0932612.9
 (SQL Overall)1786912437.68923239.8
 
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.