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

194 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
fathom143747(None) 
fathoms1537521fathoms
atom67824522_at_om
bathos116215632bathos
fandom122110892fandom
fantom112110802fantom
father125116712father
fathomed1744732fathomed
fathomer1645292fathomer
fatso85113492fatso_
fatsos9389422fatsos
pathos115516692pathos
abhor10411063_abhor
abohm1247973_abohm
achoo10315083_achoo
ahem97225363_a_hem
ahoy101919183_a_hoy
altho86312603altho_
anthem113410343anthem
atoms76817563_at_oms
atomy107415193_at_omy
atop66124753_at_op
author939763author
axiom143913593_axiom
barhop13319643barhop
batboy1387533batboy
bath95940083bath__
bathe105822883bath_e
bathed125518743bathed
bather115322513bather
bathes116524833bathes
bathroom1545483bathroom
baths105922923bath_s
baton75822423bat_on
bottom1048723bottom
cachou13310623cachou
cahow135110943ca_how
carhop133610763carhop
carom95025563ca_rom
carrom10513403carrom
cashoo11312253cashoo
cathode1338993cathode
cation83925503cation
dato56129943dat_o_
datos65222783dat_os
datto65416423datto_
dattos74311903dattos
datum8310633dat_um
diatom939453diat_om
eath75735663eath__
ethos85514193_ethos
faction122613333faction
factor11911453factor
fado87226463fa_do_
fados95620733fa_dos
faggot1139053faggot
fagot9323403fa_got
faith115620853faith__
faithed1437163faithed
faiths124610273faith_s
falcon11310293falcon
fallow124713853fallow
fandoms13229473fandoms
fanion94514323fanion
fano75831693fa_no_
fanon84619013fa_non
fanos85926503fa_nos
fantasm1236593fantasm
fantod102010033fantod
fantoms12189153fantoms
fanum10313443fa_num
farm95934533fa__rm
faro76136923fa_ro_
faros85532023fa_ros
farrow12309973farrow
farther1348343farther
fash107232293fash__
fashed136720253fashed
fashes124524023fashes
fashion1337843fashion
fat68178083fat___
fatal84819373fat_al
fate75444283fat__e
fated95632133fat_ed
fates85139233fat_es
fathead1437863fathead
fathers133916503fathers
fathomers1744953fathomers
fathoming1844693fathoming
fating105328673fating
fatly115716803fat_ly
fats76252503fat__s
fatsoes10379423fatsoes
fatted105419843fatted
fatten94314903fatten
fatter94523213fatter
fatty115117413fat_ty
fatuous1037783fatuous
fatwa1168063fat_wa
fatwas1249053fatwas
fatwood1486393fatwood
favism1437913favism
favor114712453fa_vor
feather133613503feather
fetor81214533fet_or
flattop1244403flattop
flatworm1645173flatworm
from96923923f__rom
fulham1435303fulham
futhorc1544313futhorc
futhork1745103futhork
futon83113773fut_on
gather104115853gather
gator64416033gat_or
hansom11219153hansom
hatbox1835133hatbox
hath105933913hath__
jato115822683jat_o_
jatos125116823jat_os
jetsom15126143jetsom
kathode1545733kathode
kation104315683kation
lath76640383lath__
lathe85626713lath_e
lathed104718453lathed
lather95124353lather
lathes95127493lathes
lathi85417203lath_i
lathis95516173lathis
laths86022403lath_s
lathy115215063lath_y
litho86513783litho_
lithos94212553lithos
macho126120153macho_
machos135217493machos
madtom1138023madtom
mahoe10315573ma_hoe
maihem1366213maihem
math95437453math__
maths105624023math_s
matron83918313matron
matzo16312893matzo_
matzoh2035483matzoh
matzos1749263matzos
matzot17710983matzot
mayhem1644923mayhem
method1239023method
mythoi14417133mythoi
mythos14398463mythos
nacho105414383nacho_
nachos115014183nachos
nation64322803nation
natron64116023natron
oath76132153oath__
oaths86117313oath_s
ortho8312293ortho_
path99134913path__
paths105521383path_s
patio74426353patio_
patios85221783patios
patrol83213023patrol
patron84018043patron
pothos114214693pothos
python1447143python
random92513553random
ransom82410943ransom
rath76037663rath__
rathe85821923rath_e
rather94319743rather
rathole10312053rathole
ratio55227583ratio_
ration64226013ration
ratios64922673ratios
rato45436973rat_o_
ratoon64417373ratoon
ratos55528763rat_os
ratton64116123ratton
sachem134012223sachem
satem76021463sat_em
sitcom1036903sitcom
tatsoi637263tatsoi
tattoo6310973tattoo
them97427043__them
tho67433963__tho_
thou76722213__thou
tom514358053__t_om
toom66532933__toom
vagrom1235943vagrom
varoom11411413varoom
wahoo112413083wa_hoo
warthog1444533warthog
whom127018183__whom
xanthoma2043973xanthoma
yahoo112911543ya_hoo

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.1401276364.3
2DLD Change Limit1127161945.31321215.1
3Display Results1941940.0603233.3
 (SQL Overall)1786911945.51332412.7
 
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.