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

274 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
fullam113836(None) 
fulham1435301fulham
fullams1236551fullams
bulla74620562bulla_
bullae83416162bullae
cullay113910172cullay
fallal93612692fallal
fella84918652fella_
fellah124910772fellah
fellas95116962fellas
flam96333292f__lam
fleam106017282f_leam
fulhams1543982fulhams
full75229152full__
fulled103820652fulled
fuller94220382fuller
fulls84623522full_s
fully114820862full_y
fulmar1137252fulmar
mulla74317112mulla_
mullah113710732mullah
mullas84215932mullas
nullah9388142nullah
agleam9158623agleam
allay85620393_allay
alula5317093alula_
alulae6312743alulae
alular6311353alular
ballad94315323ballad
balsam105612233balsam
bedlam1149273bedlam
beldam11410113beldam
blam86131703__blam
bulbar1039583bulbar
bull65634873bull__
bullace113410673bullace
bullate93415073bullate
bullbat1158553bullbat
bulled94626493bulled
bullet84528613bullet
bulls75629573bull_s
bully105124813bull_y
burlap1098353burlap
calla74827073calla_
callan83619603callan
callas84526753callas
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
clam86332293__clam
collar83816173collar
cull65929643cull__
cullays12347703cullays
culled94022473culled
culler84322253culler
cullet84727313cullet
cullis84115993cullis
culls75425813cull_s
cully105520463cull_y
culm85822383cu_l_m
culpa93610963culpa_
culpae10389263culpae
cutlas8313103cutlas
dollar74110983dollar
dulia61014983dulia_
dulias71212743dulias
dull56430443dull__
dullard936603dullard
dulled84719423dulled
duller74017703duller
dulls64523743dull_s
dully94921633dull_y
dunam8313733du_nam
fall75535313fall__
fallacy1536433fallacy
fallals103310193fallals
fallen93813373fallen
faller94621233faller
fallow124713853fallow
falls85727653fall_s
fell76833073fell__
fellahs13428393fellahs
fellate10313433fellate
felled103720303felled
feller94419553feller
felloe93513923felloe
fellow123712743fellow
fells85327383fell_s
felly114922803fell_y
ferbam1339003ferbam
fila74729133f_ila_
filar84819293f_ilar
filial93013253filial
fill75540193fill__
fille84327403fill_e
filled104922263filled
filler94623623filler
filles94224523filles
fillet95027083fillet
fillip11268953fillip
fillo84319783fill_o
fillos94415083fillos
fills84632373fill_s
filly114424903fill_y
film94828173f_il_m
filum105015433f_ilum
flab96628353f__lab
flag87427083f__lag
flak116026173f__lak
flame105124443f__lame
flams105125013f__lams
flamy135217473f__lamy
flan76134183f__lan
flap96128703f__lap
flat77147823f__lat
flaw106326643f__law
flax147325633f__lax
flay106332803f__lay
flea75628493f_lea_
fleams115011943f_leams
fleas86423663f_leas
float85928573f_loat
foam97127173f__oam
folia83618933folia_
foliar93210973foliar
folium11310453folium
folles93820473folles
follis93113903follis
follow124010353follow
folly115022603foll_y
foram105124933f_oram
foully1239013foull_y
fubar1039923fu_bar
fuel76824733fuel__
fueled104913603fueled
fueler94313933fueler
fuelled11369193fuelled
fueller10279963fueller
fuels87117353fuel_s
fugal95613033fu_gal
fugle94915543fugl_e
fugled114813693fugled
fugles104715783fugles
fulcra1135213fulcra
fulcrum1443483fulcrum
fulfil1246423fulfil
fulgid1137043fulgid
fullback1943853fullback
fullers103817373fullers
fullery13337973fullery
fullest10313343fullest
fullface1642553fullface
fulling114019703fulling
fulmars1246423fulmars
fulsome1245363fulsome
fungal10388733fungal
furan84320013fu_ran
furl77030883furl__
furled104717053furled
furler93616403furler
furls85322053furl_s
fusuma1134503fusuma
glam76529343__glam
gleam86916733_gleam
gloam86015943_gloam
gulag7310823gu_lag
gular6314833gu_lar
gull54828453gull__
gulled84521373gulled
gullet74924833gullet
gulley104213163gulley
gulls65222983gull_s
gully94020683gull_y
hallah124115403hallah
hallal94415563hallal
holla84918493holla_
hollas94616903hollas
hula74923753hu_la_
hulas84920883hu_las
hull75428783hull__
hulled103920013hulled
huller93919103huller
hullo84417453hull_o
hulloa95011183hulloa
hulloas103911913hulloas
hulloo94511733hulloo
hullos94916293hullos
hulls84923563hull_s
kalam11315113_kalam
kulak858823ku_lak
lallan63414173lallan
lam57666713___lam
llama799893__llama
loam65630483__loam
lull44225763lull__
lullaby1243363lullaby
lulled74516443lulled
luller63415483luller
lulls54119653lull_s
milldam1245473milldam
mollah11319453mollah
mull65128803mull__
mullahs12388733mullahs
mulled94721553mulled
mullen83714763mullen
muller83820353muller
mullet84126823mullet
mulley114013453mulley
mulls75124153mull_s
null45125313null__
nullahs10316993nullahs
nulled74318273nulled
nulls55019983null_s
olla44821173_olla_
ollas54218283_ollas
outlaw9279643outlaw
outlay92711793outlay
pillar8314023pillar
pula65129373pu_la_
pull64731663pull__
pulled94322193pulled
puller83820813puller
pullet84026333pullet
pulley113713403pulley
pullman1135403pullman
pulls74425053pull_s
pullup1045893pullup
pulpal10408453pulpal
pulsar8329363pulsar
qualm163511183qual_m
quillai1644993quillai
salaam8711013salaam
slam67737973__slam
sulcal8311273sulcal
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sullage859913sullage
sullen62914293sullen
sully84622903sull_y
sultan63012593sultan
sunlamp1144163sunlamp
tulle54019933tull_e
tulles63218893tulles
uhlan849113_uhlan
ulama7711473_u_lama
ulan46527393_u_lan
ulema7109713_ulema
ullage739043_ullage
ulna46317323_ulna_
ulnad65611453_ulnad
ulnae55214573_ulnae
ulnar56013983_ulnar
ulnas55716533_ulnas
ulpan7310123_ulpan
ulva75412693_ulva_
ulvas84511503_ulvas
unjam1448723_unjam
unlay84613703_unlay
vellum1136773vellum
villa85321233villa_
villae95615383villae
villas96117263villas
vulgar10426823vulgar
vulva11448803vulva_
vulvae12438033vulvae
vulval12417663vulval
vulvar12427963vulvar
vulvas12388843vulvas
walla85321033walla_
wallah124011993wallah
wallas95719393wallas
yulan8411493yu_lan
zillah1836563zillah

Search took 7 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.376475242.0
2DLD Change Limit1127162745.70319764.3
3Display Results2742740.0763605.3
 (SQL Overall)1786912746.15529031.8
 
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.