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

280 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
designs932831(None) 
deigns8389981de_igns
design8408931design_
resigns83910961resigns
assigns836192assigns
codesigns1353662codesigns
cosigns1047512cosigns
deign74312802de_ign_
deraigns1034882deraigns
designed1136942designed
designee1087752designee
designees1145002designees
designer1036542designer
designers1136002designers
desires81316132desires
desists83611722desists
desmans1039002desmans
ensigns836352ensigns
feigns10407752fe_igns
lesions73813872lesions
redesigns1144072redesigns
reigns74811752re_igns
resign74212582resign_
resins64528772resi_ns
signs65516322__signs
adhesions1343793adhesions
aligns75312953_aligns
assign736783assign_
basins85722763basi_ns
basions94213953basions
begins94415303begi_ns
beiges91014413be_iges
beigne9148613be_igne
beignes10149243be_ignes
beings94613033be_ings
benign938313benign_
besides104814533besides
besieges1146003besieges
bewigs1246533bewig_s
busings103711223busings
casings104013513casings
cesiums1136303cesiums
cessions1039853cessions
codesign1274503codesign_
coigns94410063_coigns
consigns1137533consigns
cosign958783cosign_
darings93713653darings
deacons10310393deacons
deadens93410693deadens
deafens11317253deafens
deairs74013783deai_rs
dealings103510703dealings
deans66131393de__ans
debags104211063debag_s
debits94214503debi_ts
debugs10467823debug_s
decagons1235893decagons
decerns10119053decerns
decides114217653decides
deciles104417723deciles
decisions1248383decisions
deckings16346683deckings
dedans85915073de_dans
deepens10307813deepens
deewans11306903deewans
defangs1235363defangs
defiant11311923defiant
defiers113913993defiers
defies104624053defi_es
defiles114016843defiles
define104718143defi_ne
defines114118683defines
defis96717503defi__s
defogs1156683defog_s
degas75119163de__gas
dehorns11428363dehorns
deices94119373de_ices
deigned1037503de_igned
deils65722863de_i_ls
deisms94411043de_isms
deists74916433de_ists
deixis1437243de_ixis
deking125614553deki_ng
delicts104012253delicts
delight12610673delight
delights1347333delights
delimes10314193delimes
delis64928543deli__s
delists84414173delists
deluges9169263deluges
delusions1037053delusions
demeans1039723demeans
demies94825803demi_es
demigod1254193demigod
demigods1343983demigods
demises103719563demises
demits94918073demi_ts
demons94917723de_mons
denials84114133denials
deniers84515183deniers
denies74729643deni_es
denims95214323deni_ms
denizens1835573denizens
dens55945073de___ns
dentins83419223dentins
depicts12358463depicts
depsides1238503depsides
deraign936573deraign_
derides93420853derides
derisions1038843derisions
derives114017813derives
desalts839573desalts
desand84812633des_and
desands94810163desands
descant104315593descant
descants112910143descants
descend11248153descend
descends12266983descends
descent102616293descent
descents112511203descents
deserts82513053deserts
desexes1537833desexes
designate1147113designate
designates1246363designates
designing1236623designing
designings1342623designings
desinent9312963desinent
desire7415303desi_re
desired9311983desired
desirer8310783desirer
desirers939263desirers
desiring10312143desiring
desirous947783desirous
desist74818813desi_st
desks105913073des__ks
desman9311693desman_
desmids1166603desmids
desorbs10437713desorbs
despises1139433despises
despites11410313despites
despond1137513despond
desponds1246243desponds
despots10319683despots
destains9311813destains
destine83719953destine
destines93619663destines
destiny113111463destiny
desugar944033desugar
desugars1043373desugars
detains83716093detains
deticks1437353deticks
deveins1138813deveins
deviant11311313deviant
deviants1236733deviants
devices133212583devices
devils104412813devi_ls
devious1138523devious
devises114116763devises
devons104512253de_vons
dewans105215143de_wans
dewing114115703dewi_ng
dexies145018343dexi_es
dezinc1836053dezi_nc
dezincs1933753dezincs
diesis74013493diesi__s
digs66036063d__ig_s
dings76331403d__ings
dins56652053d__i_ns
dislimns1144813dislimns
disowns1136733disowns
djinns1443133d_jinns
djins1368453d_ji_ns
doeskins1344903doeskins
doings84913183d_oings
dopings11408783dopings
dosages92310803dosages
dosing83920273dosi_ng
drains73719403drai_ns
dressings11265373dressings
durians839573durians
durions839963durions
dustings10419033dustings
dyeings12374643dyeings
dyings11478133d_yings
edgings10256243edgings
eloigns8425353eloigns
ensign737523ensign_
eosins64419163eosi_ns
epigons1048183_epigons
etesians845473etesians
feign94210713fe_ign_
fusions1039153fusions
hemins113417573hemi_ns
hessians1145053hessians
insigne837673insigne
jestings16368023jestings
leasings9379843leasings
leggins9259473leggins
legions84611783legions
lesbians1043603lesbians
lesion64715063lesion_
lessens7409383lessens
lessons73811023lessons
levins94514653levi_ns
losings82810623losings
lysins94610953lysi_ns
maligns1038133maligns
medians103214213medians
mesian84315503mesian_
mesons83215843mes_ons
messans92710463messans
musings10389543musings
nasions73112383nasions
neighs10387733ne_ighs
nosings8349593nosings
opsins8411713opsi_ns
outdesigns1251663outdesigns
peins76128063pe_i_ns
pekins121812233peki_ns
pensions10311693pensions
pepsins11310433pepsi_ns
perigons11310083perigons
reagins84215643reagins
realigns936253realigns
reassigns1074353reassigns
redesign1045073redesign_
regions83613473regions
reign65015193re_ign_
reins56234563re_i_ns
rejigs14368093rejig_s
remiges103015473remiges
renigs74314593renig_s
renins64526453reni_ns
repins84924313repi_ns
repugns1035393repugns
rerigs74014793rerig_s
resides84523283resides
resids74219153resi_ds
resifts10378703resifts
resight11510643resight
resights1246733resights
resigned1038863resigned
resigner937793resigner
resigners1036863resigners
resiles74026543resiles
resilins83013373resilins
resin54131053resi_n_
resiny94617363resi_ny
resists74414923resists
resites74027793resites
resits64725563resi_ts
resizes164216843resizes
rewins95020823rewi_ns
risings83211893risings
rosins64521863rosi_ns
sasins64923103sasi_ns
seeings84411293seeings
seisings9398523seisings
seisins73614393seisins
serins64029673seri_ns
sessions839723sessions
sewings11369173sewings
sighs95416743__sighs
sign55523063__sign_
signa66114703__signa
sings65532703__sings
sins46755283__si_ns
tensions8310223tensions
testons7313563testons
undersigns1265833undersigns
veins84620493ve_i_ns
venins93816703veni_ns
versions11310353versions
vestiges1238243vestiges
vestings12359143vestings
visions10311023visions
weighs13338873we_ighs
westings12429803westings
zeins144715393ze_i_ns

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272806.79619721.5
3Display Results2802800.1102545.5
 (SQL Overall)1786912807.31224438.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.