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

134 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
fulham143530(None) 
fulhams1543981fulhams
fullam1138361fullam
flam96333292f_l_am
fleam106017282f_leam
fullams1236552fullams
fulmar1137252fulmar
agleam9158623agleam
balsam105612233balsam
beldam11410113beldam
blam86131703_bl_am
bulbar1039583bulbar
bulla74620563bulla_
bullae83416163bullae
cham115532313__cham
clam86332293_cl_am
cullay113910173cullay
culm85822383cul__m
culpa93610963culpa_
culpae10389263culpae
cushat113513693cushat
cushaw14386983cushaw
dirham12378273dirham
dulia61014983dulia_
dulias71212743dulias
dunam8313733du_nam
fallal93612693fallal
fathom1437473fathom
fella84918653fella_
fellah124910773fellah
fellas95116963fellas
ferbam1339003ferbam
fila74729133fil_a_
filar84819293fil_ar
filial93013253filial
film94828173fil__m
filum105015433fil_um
flab96628353f_l_ab
flag87427083f_l_ag
flak116026173f_l_ak
flame105124443f_l_ame
flams105125013f_l_ams
flamy135217473f_l_amy
flan76134183f_l_an
flap96128703f_l_ap
flat77147823f_l_at
flaw106326643f_l_aw
flax147325633f_l_ax
flay106332803f_l_ay
flea75628493f_lea_
fleams115011943f_leams
fleas86423663f_leas
float85928573f_loat
foam97127173f__oam
folia83618933folia_
foliar93210973foliar
folium11310453folium
foram105124933f_oram
fubar1039923fu_bar
fugal95613033fu_gal
fulcra1135213fulcra
fulcrum1443483fulcrum
fulfil1246423fulfil
fulgid1137043fulgid
full75229153ful__l
fulled103820653fulled
fuller94220383fuller
fulls84623523ful_ls
fully114820863ful_ly
fulmars1246423fulmars
fulsome1245363fulsome
fungal10388733fungal
furan84320013fu_ran
fusuma1134503fusuma
futharc1563713futharc
futhark1744233futhark
glam76529343_gl_am
gleam86916733_gleam
gloam86015943_gloam
graham1237853graham
gulag7310823gul_ag
gular6314833gul_ar
ham86363283___ham
hula74923753hul_a_
hulas84920883hul_as
jubhah2142803jubhah
kalam11315113kal_am
kulak858823kul_ak
lam57666713__l_am
loam65630483__loam
mughal1236273mughal
mulla74317113mulla_
mullah113710733mullah
mullas84215933mullas
nucha10229793nucha_
nuchae11218513nuchae
nuchal11218873nuchal
nullah9388143nullah
ogham1138253_ogham
pula65129373pul_a_
pulpal10408453pulpal
pulsar8329363pulsar
salaam8711013salaam
sham96436363__sham
slam67737973_sl_am
sulcal8311273sulcal
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sulpha1135403sulpha_
sulphas1236243sulphas
sultan63012593sultan
uhlan849113_uhlan
ulama7711473_ul_ama
ulan46527393_ul_an
ulema7109713_ulema
ulna46317333_ulna_
ulnad65611453_ulnad
ulnae55214573_ulnae
ulnar56013983_ulnar
ulnas55716533_ulnas
ulpan7310123_ulpan
ulva75412693_ulva_
ulvas84511503_ulvas
unhat81119263_unhat
unjam1448723_unjam
vulgar10426823vulgar
vulva11448803vulva_
vulvae12438033vulvae
vulval12417663vulval
vulvar12427963vulvar
vulvas12388843vulvas
wham125321693__wham
yulan8411493yul_an

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.390458182.1
2DLD Change Limit1127161345.14321916.4
3Display Results1341340.0462913.0
 (SQL Overall)1786911345.57932029.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.