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

281 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
offals123589(None) 
offal1136241offal_
foals85721692_foals
ofays11488922o_fays
offers12349962offers
offs107117012off__s
opals75718352o_pals
orals55826482o_rals
ovals85413392o_vals
aals49941143__aals
afars85716513_afars
affable15117403affable
affably1855183affably
affair1234353affair
affairs1334163affairs
affrays1644063affrays
alfas87219043alfa_s
als36663023___als
annals66415923annals
appals104812943appals
argals75517713argals
baals76122703_baals
bals66354043__bals
befall114410643befall
befalls12349123befalls
boffins15329073boffins
boffola1543463boffola
boffolas1642833boffolas
boffos14568193boff_os
boffs134915503boff__s
borals86721913borals
boxfuls19113603boxfuls
bubals103513843bubals
buffalo1553723buffalo
buffalos1642863buffalos
cabals104020153cabals
canals84421673canals
coals76129603_coals
coevals1237873coevals
coffees15329573coffees
coffers154112693coffers
coffins153110193coffins
coffle14359043coff_le
coffles152610003coffles
coffs134916303coff__s
confabs1435393confabs
copals105018943copals
corals85325143corals
corrals93713853corrals
craals84113303craals
dals57145123__dals
deals65435343_deals
decals93717713decals
defats105114553defats
dhals95415443_dhals
dials64925343_dials
doffers14359853doffers
doffs125614333doff__s
dorsals84110843dorsals
dossals8379293dossals
duals65620083_duals
duffels14296453duffels
effable15106673effable
efface14366673efface
effaces15277273effaces
effs105114033eff__s
equals1538693equals
fabs98635863__fabs
fads86939873__fads
fags86939123__fags
fails85631483_fails
fall75535313__fall
falls85727653_falls
false84818123__false
falx147120783__falx
fans76247373__fans
farfals13268503farfals
farls85731113_farls
fas68262933__fa_s
fats76252503__fats
fays108535363__fays
feal713940423_feal_
fears84829393_fears
feats86432753_feats
feels85223043_feels
fells85327383_fells
ferals94216643ferals
fiars86720833_fiars
fiats85324483_fiats
fills84632373_fills
fils75838693__fils
finals94316163finals
flabs105818643_flabs
flags95321283_flags
flails94313003_flails
flams105125013_flams
flans85327973_flans
flaps105621383_flaps
flats86429743_flats
flaws115920343_flaws
flays116321053_flays
foal76630923_foal_
foams105017953_foams
focal104917673focal_
foils85025813_foils
fools86824203_fools
forams115115913forams
forays124813003forays
formals123312893formals
fouls87221433_fouls
fowls115518893_fowls
frags96322173_frags
frails93716473_frails
fraps105620553_fraps
frass85321123_frass
frats86829673_frats
frays116920103_frays
fuels87117353_fuels
fulls84623523_fulls
furls85322053_furls
gals57946503__gals
gayals1039513gayals
goals65521293_goals
goffers14409213goffers
goorals838703goorals
gorals76917653gorals
graals74112913graals
guffaws1762273guffaws
halals95018313halals
hamals114816823hamals
heals85733453_heals
ideals75012503ideals
infall939403infall
infalls1038943infalls
jacals1539873jacals
jouals1338923jouals
kraals10378433kraals
legals73412733legals
locals83714503locals
loofahs13364623loofahs
loofas9429833loofa_s
luffas12337483luffa_s
meals75933373_meals
medals94218053medals
metals84520883metals
modals93914453modals
morals85324633morals
mortals93914003mortals
murals84016763murals
nasals63312463nasals
nonfans1037533nonfans
nopals84914023nopals
normals92510903normals
oafs76425263o__afs
oaks86527903o__aks
oars46846033o__ars
oats46554213o__ats
obas65730933o_ba_s
obeahs1135863obeahs
obias76116863obia_s
obols73715863o_bols
ocas66729633o_ca_s
oceans81211003oceans
octads987333octads
octal71214723octal_
octans81411143octans
octyls11135323octyls
odahs95610083o_dahs
odas57230263o_da_s
odyls9428653o_dyls
ofay106416103o_fa_y
off96331633off___
offbeats1682813offbeats
offcast1544473offcast
offcasts1643013offcasts
offcut1444703offcut
offcuts1542573offcuts
offed12359163off_ed
offend13365663offend
offends14234293offends
offense1343683offense
offer114311383off_er
offhand1742883offhand
office1435693office
offices1536243offices
officials1743403officials
offing13368643offing
offings14285833offings
offish15137273offish
offkey1932343offkey
offloads1542723offloads
offramp1742153offramp
offramps1841653offramps
offset1238373offset
offsets1333503offsets
ogams84112683o_gams
oghams1245853oghams
ohias84415573ohia_s
oils46337973o__ils
okas85225393o_ka_s
okays12609443o_kays
okras94410973okra_s
ollas54218283olla_s
onlays9398713onlays
oorali6311263oorali
ooralis7312553ooralis
opahs105411983o_pahs
opal66923523o_pal_
oral47638123o_ral_
orcas75918623orca_s
ordeals877993ordeals
oreads73915773oreads
orfrays1343533orfrays
organs7912913organs
oriels64914623oriels
osmols8137313osmols
ottars64112223ottars
ousels64815273ousels
outfall1039683outfall
outfalls1138143outfalls
ouzels15408703ouzels
oval77119523o_val_
owls76022933o__wls
oxalis1339223o_xalis
oxtails1436383oxtails
pals66951353__pals
peals75235493_peals
pedals94316033pedals
petals84719813petals
phials1158873phials
pibals103813083pibals
pipals104213643pipals
portals94015563portals
postals93716373postals
potfuls1236293potfuls
ratals64219583ratals
reals55038653_reals
refall94314393refall
refalls103312243refalls
refels94618053refels
rials55026673_rials
rivals94213183rivals
riyals94111083riyals
royals93711263royals
sabals84618863sabals
salals65120083salals
sals46851673__sals
seals54839693_seals
sepals85217373sepals
sheals94420643sheals
shoals94215793shoals
sials54227243_sials
sisals63013573sisals
skoals10438243skoals
socials999633socials
sofars94712783sofars
sofas85320713sofa_s
soffits1335093soffits
softas94410403softa_s
steals64020063steals
tamals84116633tamals
teals56234133_teals
tepals85415043tepals
ticals83214713ticals
toffees13327083toffees
toffies133210213toffies
toffs116016723toff__s
totals63115163totals
trials64319883trials
tufas85314383tufa_s
urials64415193urials
usuals637783usuals
veals84926193_veals
vials85822383_vials
vinals94716483vinals
vitals94514303vitals
vocals113811583vocals
weals85428743_weals
wheals124512523wheals
zaffars22325233zaffars
zeals145320853_zeals

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.406440125.6
2DLD Change Limit1127162816.26617988.5
3Display Results2812810.0933021.5
 (SQL Overall)1786912816.76526414.0
 
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.