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

214 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
defoam123856(None) 
defoams1336191defoams
deform1259621deform
defame123212432def_ame
defat95426692def_at
defeat103817162defeat
defoamed15356242defoamed
defoamer14276212defoamer
defog1048522defo_g
defogs1156682defogs
deforms1337802deforms
defrag1136462defrag
defray1337642defray
deiform1336692deiform
deworm1249532deworm
foam97127172__foam
reform11312712reform
adenoma1045403adenoma
beam86939233be__am
bedlam1149273bedlam
beflag1265883beflag
befog1159013befo_g
befogs1246453befogs
befool1137713befool
before11410153before
befoul1137253befoul
beldam11410113beldam
bemoan10310253bemoan
besom95716973beso_m
beworm1339993beworm
bezoar1736913bezoar
biform1368123biform
celom9515693celo_m
dam67457043d___am
dead65434243de__ad
deaf85838403de__af
deal56347413de__al
dean56039483de__an
dear55343603de__ar
debag94212303de_bag
debar85517863de_bar
debeak1336763debeak
debone93714783debone
decaf114919443de_caf
decal85523233de_cal
decamp1338453de_camp
decay114718483de_cay
declaim1247363declaim
declaw1266703declaw
deco76125973deco__
decoct11313783decoct
decode104414743decode
decor84717573deco_r
decors94017773decors
decorum1246943decorum
decos85522123deco_s
decoy115716313deco_y
decoys123911283decoys
dedal75719023de_dal
deejay1734523deejay
deem75432893de__em
deewan10267553deewan
def76546723def___
deface123113863deface
defamed14309833def_amed
defamer132710323def_amer
defames132812253def_ames
defang1137753defang
defats105114553defats
defeats113511233defeats
defect124816173defect
defend113910493defend
defer94619753def_er
defers105116943defers
deffer134411303deffer
defi86321493def__i
defiant11311923defiant
defied115016383defied
defier105118653defier
defies104624053defies
defile105216663defile
define104718143define
defis96717503def_is
deflate113613943deflate
deflea1037443deflea
defleas1147223defleas
defoamers15285253defoamers
defoaming1645653defoaming
defocus1335283defocus
deforce13267243deforce
deformed15248263deformed
deformer14247943deformer
defrags1236193defrags
defraud1243913defraud
defrays1436113defrays
defrock1744643defrock
defrost1139553defrost
deft85540223def__t
defter104215923defter
deftly1336533deftly
defuel10348933defuel
defund11447983defund
defuse105712723defuse
defuze19487843defuze
defy114921263def__y
degame102713183de_game
degami10279013de_gami
degas75119163de_gas
degerm1037893degerm
degum94711903de_gum
dehorn10439653dehorn
dehort104618103dehort
deism84116033de_ism
delay94820633de_lay
delead84112343delead
delta66117773delta_
deltas74414823deltas
demean9510563demean
demo77427553demo__
demob104913503demo_b
demobs11429483demobs
demode104013463demode
demoed103713443demoed
demon86520313demo_n
demons94917723demons
demos86022993demo_s
demote94817803demote
denar65223293de_nar
denial74720513denial
denim85518843de_nim
denote74118043denote
dental74319173dental
deodar837713deodar
deoxy1648883de_oxy
deperm1139363deperm
depone93616553depone
deport94922393deport
deposal1037153deposal
depose94215763depose
depot85727923depo_t
depots94716343depots
derat65044083de_rat
deray95024183de_ray
derm76031893de__rm
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
desman9311693desman
desorb95210203desorb
desoxy1744623desoxy
detour778193detour
detox13310953deto_x
deva85720983de_va_
devas96218883de_vas
devoid1189363devoid
devoir1076033devoir
devon95113683devo_n
devons104512253devons
devote104513783devote
devour1076703devour
devout10712993devout
dewan95718043de_wan
dewar95817733de_war
dewax165510853de_wax
dewlap1264843dewlap
dewool1047403dewool
deworms1338033deworms
diram84419473d_iram
dirham12378273dirham
doat56947673d__oat
dom69752443d__o_m
doom76430073d__oom
dorm76834633d__orm
doum76226673d__oum
dram75832003d__ram
dream85120393d_ream
dunam8313733d_unam
enorm74415643_enorm
exam132514623_e_xam
ferbam1339003ferbam
flam96333293__flam
foal76630923__foal
foams105017953__foams
foamy135313203__foamy
foram105124933__foram
form95836873__form
genoa64315823genoa_
genoas74013623genoas
genom83716843geno_m
gloam86015943_gloam
inform11310153inform
jetsam15116323jetsam
loam65630483__loam
megohm14124193megohm
perform1439283perform
preform1439613preform
ream65841613re__am
recoal84117983recoal
recoat84024273recoat
refilm114311403refilm
reflag1098083reflag
refloat10310833refloat
refold103812113refold
reforms1239823reforms
reframe1239393reframe
reload7413893reload
reloan6415693reloan
resoak10311093resoak
reteam83214533reteam
roam67132413__roam
seam66645973se__am
team66238653te__am
venom103914863veno_m
webcam1545543webcam

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.376475242.0
2DLD Change Limit1127162144.73323814.9
3Display Results2142140.0633396.8
 (SQL Overall)1786912145.17234549.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.