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

315 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
fellah12491077(None) 
fella84918651fella_
fellahs13428391fellahs
fellas95116961fellas
cella75420312cella_
cellae84915932cellae
cellar84514982cellar
fallal93612692fallal
fell76833072fell__
fellahin1444512fellahin
fellate10313432fellate
felled103720302felled
feller94419552feller
felloe93513922felloe
fellow123712742fellow
fells85327382fell_s
felly114922802fell_y
fullam1138362fullam
hallah124115402hallah
keblah1545312keblah
mollah11319452mollah
mullah113710732mullah
nullah9388142nullah
selah8319612se_lah
wallah124011992wallah
zillah1836562zillah
allay85620393_allay
almah106917253_almah
avellan1037303avellan
ballad94315323ballad
bedlam1149273bedlam
beflag1265883beflag
beglad10138463beglad
belay105021523be_lay
belch124415503be_lch
beldam11410113beldam
beleap10410283beleap
belga8313233belga_
belgas9311713belgas
bell66237183bell__
belle75827833bell_e
belled94626193belled
belles85325993belles
bellman1137183bellman
bellow114213353bellow
bells76432163bell_s
belly104625493bell_y
blah98625063__blah
bulla74620563bulla_
bullae83416163bullae
calla74827073calla_
callan83619603callan
callas84526753callas
celiac101910433celiac
cell65031723cell__
cellars93713693cellars
celled94420323celled
celli76717693cell_i
cello74919583cell_o
cellos84517803cellos
cells75428063cell_s
chalah143511663chalah
challah15458323challah
collar83816173collar
cullay113910173cullay
declaw1266703declaw
delay94820633de_lay
delead84112343delead
delish105215613delish
dell56938203dell__
dells66630943dell_s
delly96023873dell_y
delta66117773delta_
deltas74414823deltas
dewlap1264843dewlap
dollar74110983dollar
eclat7523603_eclat
elan46734243_e_lan
ell36735683_ell__
ells46431353_ell_s
ephah1337063_ephah
fall75535313fall__
fallacy1536433fallacy
fallals103310193fallals
fallen93813373fallen
faller94621233faller
fallow124713853fallow
falls85727653fall_s
favella1336173favella_
favellas1446163favellas
feal713940423fe__al
fealty122910223fealty
fear75337793fe__ar
feat76458223fe__at
fecal105119213fe_cal
fecial114714623fecial
fecula113310053fecula_
feculae12339203feculae
feel75233843feel__
feeler93215173feeler
feels85223043feel_s
feh96136093fe___h
felid94717173fe_lid
felids103111623felids
feline94820143feline
fellable13179133fellable
fellaheen15102143fellaheen
fellated1239563fellated
fellates11312753fellates
fellatio1145683fellatio
fellator1176713fellator
fellers104117543fellers
fellest10313753fellest
fellies104119743fellies
felling113321133felling
felloes104114383felloes
fellows134212433fellows
felon84619293fe_lon
felons93615763felons
felony123710323felony
felsic1147053felsic
felspar1243283felspar
felt75146933fe_l_t
felted103714653felted
felts85324543fe_lts
female11310553female
fenland1135693fenland
feral85424653fe_ral
ferals94216643ferals
ferbam1339003ferbam
feria85922713feria_
feriae95618603feriae
ferial94621253ferial
ferias95020393ferias
ferlie92814053ferlie
ferly115517353ferl_y
ferula93011173ferula_
ferulae10309603ferulae
ferulas103110753ferulas
festal94213563festal
feta76528903fe_ta_
fetal85623373fe_tal
fetas85624403fe_tas
fetch134913473fe_tch
fetial95716193fetial
fetich1479693fetich
fetish12310373fetish
feuar8310243fe_uar
feudal1037683feudal
feyly14429513feyl_y
fila74729133f_ila_
filar84819293f_ilar
filch134813323f_ilch
filial93013253filial
fill75540193fill__
fille84327403fill_e
filled104922263filled
filler94623623filler
filles94224523filles
fillet95027083fillet
fillip11268953fillip
fillo84319783fill_o
fillos94415083fillos
fills84632373fill_s
filly114424903fill_y
filth115015823f_ilth
flab96628353f__lab
flag87427083f__lag
flak116026173f__lak
flam96333293f__lam
flan76134183f__lan
flap96128703f__lap
flash115716213f_lash
flat77147823f__lat
flaw106326643f__law
flax147325633f__lax
flay106332803f__lay
flea75628493f_lea_
fleam106017283f_leam
fleas86423663f_leas
fleech14367343fleech
flench144010813flench
flesh115013743f_lesh
fletch14388193fletch
float85928573f_loat
flush115116073f_lush
folia83618933folia_
foliar93210973foliar
folles93820473folles
follis93113903follis
follow124010353follow
folly115022603foll_y
fuelled11369193fuelled
fueller10279963fueller
fulham1435303fulham
full75229153full__
fullams1236553fullams
fulled103820653fulled
fuller94220383fuller
fulls84623523full_s
fully114820863full_y
fulmar1137253fulmar
galah95917643_galah
gelcap1136213gelcap
gellant83214053gellant
gelled84718893gelled
gerah9315303ge_rah
halalah13429393halalah
hallahs133912463hallahs
hallal94415563hallal
halvah15499833halvah
health124712143health
heliac111010893heliac
hell75637893hell__
hellcat12410173hellcat
helled104024703helled
heller93322513heller
hellish13310723hellish
hello86522983hell_o
hellos95321683hellos
hells85032043hell_s
holla84918493holla_
hollas94616903hollas
jell117125873jell__
jellaba1643883jellaba
jelled144916063jelled
jello126716273jell_o
jellos134714283jellos
jells125522163jell_s
jelly154218253jell_y
jetlag1434523jetlag
keblahs1634563keblahs
keddah1534273keddah
kelly124617023kell_y
kiblah1535583kiblah
lallan63414183lallan
medlar93010463medlar
megillah1443233megillah
mell64935613mell__
melled95023023melled
mellow114112223mellow
mells75031333mell_s
mollahs12328283mollahs
moolah11409193moolah
mulla74317113mulla_
mullahs12388733mullahs
mullas84215933mullas
nellie63614813nellie
nelly84618813nell_y
nullahs10316993nullahs
ocellar936533ocellar
olla44821173_olla_
ollas54218283_ollas
paella8410913paella_
paellas9411413paellas
pedlar93311273pedlar
pellet83326553pellet
pepla9312863pepla_
pillar8314023pillar
reclad9311873reclad
reflag1098083reflag
relax124817803re_lax
relay84424673re_lay
relish93916953relish
reload7413893reload
reloan6415693reloan
replan83215823replan
replay113412923replay
selahs9313213se_lahs
sell45840613sell__
selle54428313sell_e
seller63824603seller
selles64426983selles
sells55134433sell_s
selva83014273selva_
selvas93812913selvas
shellac1236693shellac
stella63612973stella_
stellar72610433stellar
stellas72813043stellas
tela45532973te_la_
telae54323293te_lae
telia55821143telia_
telial65815363telial
tell44934703tell__
teller63519823teller
tells55828943tell_s
telly84920823tell_y
tellys9348843tellys
tesla55612603tesla_
teslas64212173teslas
vela75725543ve_la_
velar85817633ve_lar
vellum1136773vellum
villa85321233villa_
villae95615383villae
villas96117263villas
walla85321033walla_
wallahs13409473wallahs
wallas95719393wallas
wealth12379223wealth
welch134411493we_lch
well75832043well__
welled103820213welled
wellie92814913wellie
wells85426193well_s
welly114620013well_y
welsh113110363we_lsh
yeah106725413ye__ah
yell76028323yell__
yelled104116253yelled
yeller94214513yeller
yellow12429883yellow
yells85821943yell_s
zillahs1935383zillahs

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 Limit1127163155.81319390.3
3Display Results3153150.0933387.1
 (SQL Overall)1786913156.28228444.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.