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

236 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
faggot113905(None) 
faggots1234861faggots
faggoty1542861faggoty
fagot9323401fa_got
maggot10311711maggot
argot67728652_argot
fagged124717702fagged
faggoted1443102faggoted
faggotry1641672faggotry
faggy136514372fagg_y
fagots1039962fa_gots
forgot104318132forgot
maggots1136562maggots
maggoty1444012maggoty
magot8326392ma_got
waggon1136392waggon
abbot9318453_abbot
afoot8420113_afoot
agent65829643_agent
aggadot1045183_aggadot
agger76420893_agger
aggie73415013_aggie
aggro738013_aggro
aggros836553_aggros
agio57828453_agio_
agios65919863_agios
agist66325583_agist
aglet65534143_aglet
aglow94711973_aglow
ago48845523_a_go_
agog68019003_a_gog
agon56531883_a_gon
agorot7415003_agorot
algor6513053_algor
allot54933873_allot
angst6415493_angst
argol65317263_argol
argon65520593_argon
argots74116033_argots
ascot76522513_ascot
aught95120703_aught
bagged114519903bagged
bagger104619203bagger
baggie102912193baggie
baggy125615683bagg_y
baguet9316103baguet
ballot84624093ballot
begot84625953_begot
bigot84828323_bigot
cahoot11416473cahoot
cannot83616773cannot
cargo85322073cargo_
cargos94619183cargos
carrot8423123carrot
catgut9310803catgut
caught124911683caught
dagga839543dagg_a
daggas937973daggas
dagger95017303dagger
daggle93711903daggle
dago65725093da_go_
dagos76419443da_gos
diglot83014333diglot
doggo84410703doggo_
eaglet73722583eaglet
ergot65422893_ergot
facet106038523fa_cet
fact97142543fa__ct
factor11911453factor
fadeout11410193fadeout
fadge104817003fadg_e
fadged124712363fadged
fadges114814033fadges
fado87226463fa_do_
fados95620733fa_dos
fag76852363fa_g__
faggier12309843faggier
faggiest132910183faggiest
fagging133714763fagging
faggoting1543313faggoting
fagin9216573fa_gin
fagins10513863fagins
fagoted1236073fa_goted
fagoter1135883fa_goter
fags86939123fa_g_s
faint85837063fa_int
falcon11310293falcon
fallout10313503fallout
fallow124713853fallow
fandom122110893fandom
fang85432553fang__
fanga96119623fang_a
fangas105017193fangas
fanged114318223fanged
fangs96224073fang_s
fanion94514323fanion
fanjet16311393fanjet
fano75831693fa_no_
fanon84619013fa_non
fanos85926503fa_nos
fantod102010033fantod
fantom112110803fantom
fanwort13310733fanwort
faro76136923fa_ro_
faros85532023fa_ros
farrow12309973farrow
fart76860563fa__rt
fast77052313fa__st
fat68178083fa___t
fathom1437473fathom
fatso85113493fatso_
fatsos9389423fatsos
faucet115816553faucet
faugh125712963faug_h
fault85428313fa_ult
favor114712453fa_vor
fidget114216483fidget
figged124013893figged
fight124027093f_ight
figwort1448223figwort
flagged13459633flagged
flagger12469353flagger
flaggy14415923flagg_y
flagon1037983flagon
flight134014813flight
fogbow1544783fogbow
fogdog1234223fogdog
fogged125518373fogged
fogger114414783fogger
foggy136714543fogg_y
foot76248013f__oot
forgat104018583forgat
forget106326393forget
forgo94418333forgo_
fought135112393fought
fragged134010163fragged
fraught14266353fraught
fright133715243fright
fugato1036223fugato
fugged124615383fugged
fuggy135411673fugg_y
fugio9310923fugio_
fugios1037583fugios
fungo94413133fungo_
fylfot1545043fylfot
gadget93616183gadget
gagged104817153gagged
gagger95016513gagger
gaggle93412623gaggle
galiot72322593galiot
galoot72719163galoot
garget84327273garget
gavot9321123ga_vot
giglot84013133giglot
gigot74023073_gigot
got49870443___got
grot55942053__grot
hagbut1278923hagbut
hagdon1188283hagdon
haggadot1444063haggadot
hagged124317703hagged
haggis11209513haggis
haggle113511983haggle
hallot95426783hallot
hangout11411393hangout
harlot94422803harlot
hogget114715763hogget
ingot61221063_ingot
jabot14321513ja_bot
jagg136115313jagg__
jagged164115353jagged
jagger154016003jagger
jaggs148111493jagg_s
jaggy175913143jagg_y
jargon1448823jargon
lagged95520133lagged
lagger85919833lagger
lagoon7410483lagoon
largo65319783largo_
largos74815063largos
magnet9320663magnet
magots9312363ma_gots
mango85724323mango_
mangos94319333mangos
marmot10318743marmot
mascot104016073mascot
matzot17710983matzot
nagged93916053nagged
nagger84016123nagger
naggy106612823nagg_y
naught104312493naught
nugget8311723nugget
pagod95013683pa_god
parget94529393parget
pargo86723723pargo_
pargos95719043pargos
parrot8320663parrot
ragg65622693ragg__
ragged94620263ragged
raggee84217603raggee
raggle83712883raggle
raggs75216473ragg_s
raggy106116573ragg_y
ragout7317183ragout
ragtop936683ragtop
ragwort11510743ragwort
sabot7931783sa_bot
sagbut959753sagbut
sagest74920263sagest
saggar84010853saggar
sagged94120013sagged
sagger84321073sagger
saggy105917463sagg_y
sago56332673sa_go_
sagos66123873sa_gos
sargo65424413sargo_
sargos74318273sargos
spigot9312603spigot
taggant9310223taggant
tagged93418123tagged
tagger84017703tagger
tango66921173tango_
tangos74216303tangos
target75028903target
tarot55943933ta_rot
taught104312223taught
ungot61718063_ungot
vagrom1235943vagrom
wagged124616123wagged
wagger113616013wagger
waggle113612303waggle
waggly14347293waggly
waggons1235503waggons
wagon94312953wa_gon
waught133811043waught
zagged183612513zagged

Search took 10 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.390458182.1
2DLD Change Limit1127162368.69012970.8
3Display Results2362360.466506.4
 (SQL Overall)1786912369.54618718.9
 
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.