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

505 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
fights13381655(None) 
bights124417961bights
dights114016961dights
eights103618981eights
fight124027091fight_
flights143310981flights
frights14339621frights
hights133716891hights
lights104519911lights
mights123516251mights
nights104117721nights
rights104019331rights
sights103818011sights
tights104015851tights
wights133315781wights
alights113211432alights
aughts104710242aughts
bight118728842bight_
bigots95015132bigots
blights133110212blights
brights133710232brights
dight104027002dight_
digits84114532digits
eight94928052eight_
eighth133310602eighth
eighths14388292eighths
eighty133711602eighty
fagots1039962fagots
fiats85324482fi_ats
fiches145219532fiches
fichus14388112fichus
fidgets12388762fidgets
fifths15406542fifths
fighter143010772fighter
fighters15269402fighters
figs85332642fig__s
filets94718952filets
filths12389782filths
firsts95110922firsts
firths125113502firths
fishes125221342fishes
fists85527542fi_sts
fits76043462fi__ts
flight134014812flight_
flighty17347432flighty
freights1555852freights
fright133715242fright_
gigots83911952gigots
heights14399442heights
highs125412522high_s
hight125327232hight_
highth12389152highth
highths13358002highths
infights1545572infights
knights1545652knights
lichts113712382lichts
light94429602light_
might113827082might_
mighty154310212mighty
nighs95013612nigh_s
night94327852night_
nighty135611272nighty
oughts104710182oughts
plights13299312plights
refights1555882refights
right94430502right_
righto104111092righto
righty135011832righty
sighs95416742sigh_s
sight94629292sight_
slights112810722slights
tight93626502tight_
weights14409552weights
wight123725572wight_
wrights14318992wrights
affrights1942893affrights
aghas97014873_aghas
agists75713173agists
aiglets84012913aiglets
aigrets82810533aigrets
airths95414253airths
airts55626343ai_rts
aits46355533ai__ts
alight103816863alight_
angsts738863angsts
argots74116033argots
aright103817663aright_
aught95120703aught_
bahts105617803_bahts
bedights1544743bedights
begets96215523begets
bidets95215533bidets
bighted142810923bighted
bigos85020013big_os
bigot84828323bigot_
bigs76235023big__s
binits85716673binits
bints76130183bi_nts
bionts8612393bionts
births115713603births
bits66148163bi__ts
bitts75022593bi_tts
blight124114623blight_
blighty16356843blighty
bright124215923bright_
catfights1842793catfights
cigars9910723cigars
cigs75625103cig__s
cists76624533ci_sts
civets115212543civets
delights1347333delights
dicots94915793dicots
diets66026643di_ets
digest84019623digest
digests93610613digests
dighted132511493dighted
digit73825273digit_
diglots9299503diglots
digs66036053dig__s
dints67431313di_nts
dirts66824463di_rts
dishes104622653dishes
dits56450523di__ts
divots104712203divots
dixits144210313dixits
dogfights1842033dogfights
eighties12710803eighties
eightvo1443843eightvo
eightvos1543743eightvos
ergots74512373ergots
facets116316653facets
facts107021893f_acts
faggots1234863faggots
fagins10513863fagins
fagot9323403fagot_
fags86939123fag__s
faints94818783faints
faiths124610273faith_s
fanlights1643923fanlights
farts88336843f_arts
fashes124524023fashes
fasts86429683f_asts
fats76252503f__ats
faults94513553faults
feasts95116093feasts
feats86432753f_eats
fehs106522383f_eh_s
feigns10407753feig_ns
feints94813873feints
feists94915313feists
felts85324543f_elts
fests85828043f_ests
fets75345943f__ets
fiars86720833fi_ars
fiat76646643fi_at_
fibers114717523fibers
fibres114312123fibres
fibs96329503fi__bs
fices106031163fi_ces
fiche134616743fich_e
fichu134810663fich_u
ficins113513983ficins
ficoes114613463ficoes
ficus105015493fi_cus
fidges114114393fidges
fidget114216483fidget_
fidgety15384893fidgety
fidos95819053fi_dos
fids87034743fi__ds
fiefs116213703fi_efs
fields104211043fields
fiends104110293fiends
fiesta938123fiesta
fiestas1038433fiestas
fifers125414923fifers
fifes114822393fi_fes
fifth145210923fi_fth
fifty145211423fi_fty
fig76242833fig___
figged124013893figged
fighting162710083fighting
fightings17276503fightings
figments1446943figments
figure10258833figure
figures11239113figures
figworts1544683figworts
filches153410723filches
filers94623723filers
files85441273fi_les
filet85540163filet_
filles94224523filles
fillets103414753fillets
fillos94415083fillos
fills84632373fi_lls
filmis114610283filmis
films105617963fi_lms
filos86125383fi_los
fils75838693fi__ls
filth115015823fi_lth
filthy15356423filthy
finals94316163finals
fincas113512073fincas
finches153914193finches
finds95424823fi_nds
fines86644263fi_nes
finest94321733finest
fingers113418433fingers
finis86824263fi_nis
finite9316823finite
finites10315923finites
finito9310303finito
finks125424223fi_nks
finos86226953fi_nos
fins75849093fi__ns
fiords10498623fiords
fiques1837973fiques
firers94922683firers
fires85740753fi_res
firms105217423fi_rms
firns86018543fi_rns
firs76637713fi__rs
first86226123first_
firth115819533fi_rth
fiscs105311883fi_scs
fish106926273fish__
fished134316313fished
fisher124917143fisher
fishers134714723fishers
fishnets1445633fishnets
fishy146011663fish_y
fist76248423fi_st_
fit66365453fi__t_
fitches153516193fitches
fitchets16307413fitchets
fivers124420923fivers
fives116027363fi_ves
fixate1638733fixate
fixates1737393fixates
fixers165112983fixers
fixes154723593fi_xes
fixit154819303fixit_
fixity19427813fixity
fixt1410729713fi_xt_
fizgigs2142203fizgigs
fizzes174512553fizzes
flats86429743f_lats
fleets96915063fleets
flighted1646973flighted
flints95617453flints
flirts95411483flirts
flits85625223f_lits
floats96816253floats
flouts94315273flouts
fluyts12367153fluyts
foehns12204973foehns
fogeys13509263fogeys
fogies104118063fogies
fogs87035003fog__s
fohns117310783f_ohns
foists95413983foists
fonts86124753f_onts
foots85528283f_oots
forgets113813793forgets
forts86034453f_orts
fought135112403fought_
founts94313383founts
frats86829673f_rats
fraughts15214243fraughts
freight1447603freight_
frets85523403f_rets
frigate11311063frigate
frigates12310933frigates
friges104116483frig_es
frighted1657173frighted
frighten1566443frighten
frightens1655393frightens
frigs96019273frig__s
friths124313583frith_s
frits86129103f_rits
fritts94613193fritts
fronts94415793fronts
frosts94214623frosts
froths125411443froths
fruits94512493fruits
fugato1036223fugato
fugatos1135483fugatos
fugios1037583fugios
fugles104715783fugles
fugs85730693fug__s
fugues104511683fugues
fugus95914013fug_us
fumets114311813fumets
gats56753443__gats
gets55442483__gets
ghats95818613__ghats
ghis85020163__ghis
giants74713503giants
gifts96214963gi_fts
gigas75415583gig_as
gighe10139733gigh_e
giglets93211553giglets
giglots9367863giglots
gigot74023073gigot_
gigs66631183gig__s
gigues8129003gigues
gilts64924263gi_lts
girths105612273girths
girts65423623gi_rts
gists66026193gi_sts
gits55744593__gits
gunfights1742433gunfights
guts56637253__guts
height134713433height_
heighth13366343heighth
heighths14324823heighths
high116619923high__
higher134610893higher
highest1439563highest
highly1636823highly
highted152710163highted
hightop1645013hightop
hightops1745043hightops
hilts86924413hi_lts
hints87330623hi_nts
hists86328373hi_sts
hits75545133hi__ts
ichs96214713_ich_s
iggs66612673_ig_gs
iglus6609933_iglus
ikats95311153_ikats
infight1437453infight_
ingots7912063ingots
insights1245493insights
its35538833_i__ts
jigs126524763jig__s
jilts124717413ji_lts
kilts95122183ki_lts
kists95822113ki_sts
kithes135016653kithes
kiths125814973kith_s
kits86441773ki__ts
knight1438173knight_
laighs10508803laigh_s
legits71313003legits
liches114724293liches
lichis115212593lichis
licht104723493licht_
lifts85719063li_fts
ligans76817733ligans
ligate72519253ligate
ligates82318383ligates
ligers75022043ligers
lighted122913503lighted
lighten112811523lighten
lightens122510003lightens
lighter113113443lighter
lighters123111393lighters
lightest121410353lightest
lightish1556623lightish
lightly14369023lightly
lilts55822803li_lts
limits82514143limits
lints57137193li_nts
lists56628693li_sts
lithos94212553lithos
lits46252493li__ts
magots9312363magots
miches134320733miches
midgets113910253midgets
midguts11296013midguts
midsts95510053midsts
miggs96311373mig_gs
migs76935323mig__s
milts75430713mi_lts
mints76834043mi_nts
mirths114912993mirths
mishits122513083mishits
mists76633903mi_sts
mitts75523753mi_tts
naughts11447513naughts
neighs10387733neigh_s
niches114419143niches
nidgets9358143nidgets
nigh85220663nigh__
nighed113811293nighed
nigher103612753nigher
nighest11310693nighest
nightie1179653nightie
nighties121011383nighties
nightly14449033nightly
ninths936933ninths
nits45741643ni__ts
noughts11478083noughts
ought95221543ought_
outfights1643783outfights
picots104616443picots
piglets103311793piglets
pignus937953pignus
pignuts1035613pignuts
pigouts1037593pigouts
pigs76634223pig__s
pigsty1235933pigsty
pilots84018873pilots
pinots85920273pinots
pints75936223pi_nts
pipets105714773pipets
pipits104713063pipits
pishes114722103pishes
piths105817543pith_s
pits66348743pi__ts
pivots115111903pivots
plight123513363plight_
refight1488873refight_
relights1248053relights
resights1246733resights
riches115022083riches
rifts85718643ri_fts
righted122912143righted
righter113212383righter
righters122610713righters
rightest12149583rightest
righties12711573righties
rightism14156963rightism
rightist12159143rightist
rightly14389043rightly
rigors72813713rigors
rigs55137593rig__s
riots54922013ri_ots
rishis9312453rishis
rivets94417113rivets
sifts84918923si_fts
sigh85625893sigh__
sighed113712053sighed
sigher103813703sigher
sighers113712183sighers
sighted123111523sighted
sighter113412113sighter
sighters122510603sighters
sightly14408273sightly
sightsaw1542693sightsaw
sightsee1245473sightsee
sigils73912363sigils
siglos7311473siglos
sigmas94111363sigmas
signets83311503signets
signs65516323sig_ns
silts55330823si_lts
sinhs86719603sinh_s
sits45050203si__ts
sixths16416373sixths
sleights12275913sleights
slight103416003slight_
spigots1037793spigots
sprights14167143sprights
sughs95313323sugh_s
thighs1346633thigh_s
tigers75616513tigers
tighten11288973tighten
tightens12297953tightens
tighter112910693tighter
tightest12148363tightest
tightly14327613tightly
tigons74112263tigons
tilths9459373tilths
tilts55325613ti_lts
tincts84510803tincts
tints56030923ti_nts
tithes94720213tithes
tits46145043ti__ts
tonights1244593tonights
ughs85410973_ugh_s
unsights1244623unsights
uplights14165053uplights
uprights14145313uprights
vigas94817883vig_as
vigias104110893vigias
vigils104210193vigils
vigors102911483vigors
vigs85427273vig__s
visits9311423visits
vughs12678743vugh_s
waughts14355963waughts
wechts1446253wechts
weighs13338873weigh_s
weight133914183weight_
weighty17376233weighty
whishts16425313whishts
wiches144418753wiches
widgets12318453widgets
widths1335123widths
wigans104511703wigans
wiglets113411423wiglets
wigs84931253wig__s
wilts85023503wi_lts
wishes124920953wishes
wists86728523wi_sts
withes124620843withes
wits76044873wi__ts
wright133713513wright_
yachts1437023yachts
yirths12639533yirths
yoghs125410593yogh_s
zibets1737743zibets
zigs145422793zig__s
zits136030293zi__ts

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127165055.34621084.2
3Display Results5055050.1702970.6
 (SQL Overall)1786915055.88930343.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.