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

157 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
fathoms153752(None) 
fathom1437471fathom_
atoms76817562_at_oms
bathos116215632batho_s
fandoms13229472fandoms
fantoms12189152fantoms
fathers133916502fathers
fathomed1744732fathomed
fathomer1645292fathomer
fathomers1744942fathomers
fatsoes10379422fatsoes
fatsos9389422fatso_s
fatuous1037782fatuous
pathos115516692patho_s
abhors11410623_abhors
abohms1335003_abohms
anthems12309423anthems
atom67824523_at_om_
atomy107415193_at_omy
authors10311833authors
axioms15408053_axioms
barhops14288113barhops
batboys1465833batboys
bathers124720363bathers
bathes116524833bath_es
bathoses13310453bathoses
bathrooms1644773bathrooms
baths105922923bath__s
batons85519423bat_ons
bazooms20285383bazooms
bottoms1136983bottoms
cachous14312563cachous
cahows14399123ca_hows
carhops14329703carhops
caroms105619573ca_roms
carroms11512403carroms
cashoos12310793cashoos
cathode1338993cathode
cathodes1439373cathodes
cathouse1338843cathouse
cations94524143cations
datos65222783dat_o_s
dattos74311903datto_s
datums936353dat_ums
diatoms1039073diat_oms
ethos85514193_etho_s
factions133013063factions
factious13239243factious
factors12912123factors
fados95620733fa_do_s
faggots1234853faggots
fagots1039963fa_gots
faiths124610273faith__s
falcons1239123falcons
fallows133713973fallows
famous11412393fa_mous
fandom122110893fandom_
fanions103713073fanions
fanons96115213fa_nons
fanos85926503fa_no_s
fantasms1345633fantasms
fantods11177623fantods
fantom112110803fantom_
fanums1137263fa_nums
farms106324953fa__rms
faros85532023fa_ro_s
farrows13259783farrows
fashes124524023fash_es
fashions1437243fashions
fashious1446123fashious
fastuous1145143fastuous
fates85139233fat__es
fathead1437863fathead
fatheads1536763fatheads
father125116713fath_er
fathoming1844693fathoming
fathomless1842003fathomless
fatless103212203fatless
fatness103311293fatness
fats76252503fat___s
fatso85113493fatso__
fattens105111713fattens
fatties103018203fatties
fatwas1249053fat_was
fatwood1486393fatwood
fatwoods1585953fatwoods
favisms1535443favisms
favors124211403fa_vors
feathers143513243feathers
fetors91014473fet_ors
flattops1344553flattops
flatworms1743963flatworms
fulhams1543983fulhams
futhorc1544313futhorc
futhorcs1643533futhorcs
futhork1745103futhork
futhorks1844603futhorks
futons93911513fut_ons
gathers114315063gathers
gators74115823gat_ors
hansoms12238523hansoms
jatos125116823jat_o_s
jetsoms16124723jetsoms
kathode1545733kathode
kathodes1646183kathodes
kations114013663kations
lathers104321883lathers
lathes95127493lath_es
lathis95516173lath_is
laths86022403lath__s
lithops12307253lithops
lithos94212553litho_s
machos135217493macho_s
madtoms1236923madtoms
mahoes11313103ma_hoes
maihems1444303maihems
maths105624023math__s
matrons93517633matrons
matzohs2134373matzohs
matzos1749263matzo_s
mayhems1763413mayhems
methods1338883methods
mythos14398463mytho_s
nachos115014183nacho_s
nations74720563nations
natrons73215663natrons
oaths86117313oath__s
pathoses13412763pathoses
paths105521383path__s
patios85221783patio_s
patois84319363pat_ois
patrols93513513patrols
patrons93818103patrons
pothos114214693potho_s
pythons1537363pythons
randoms102112433randoms
ransoms92410163ransoms
rathole10312053rathole
ratholes11312413ratholes
rations74123433rations
ratios64922673ratio_s
ratoons73815473ratoons
ratos55528763rat_o_s
rattons73815323rattons
sachems14348903sachems
sitcoms1145533sitcoms
tatsois748373tatsois
tattoos738643tattoos
thous86017253__thous
toms68343493__t_oms
varooms1248883varooms
wahoos122310593wa_hoos
warthogs1544823warthogs
xanthoma2043973xanthoma
xanthomas2143633xanthomas
xanthous1846623xanthous
yahoos12209243ya_hoos

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271577.72017361.0
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.93922508.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.