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

217 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
devious113852(None) 
desirous947782desirous
devices133212582devices
devils104412812devi_ls
deviously1645512deviously
devises114116762devises
devisors12347252devisors
devoirs1175782devoirs
devons104512252dev_ons
devour1076702dev_our
devours1166642dev_ours
devout10712992dev_out
diecious1146872diecious
dubious1036892dubious
envious1037222envious
obvious1244822obvious
pervious1337542pervious
previous1337822previous
serious73616282serious
tedious838442tedious
aeneous739893aeneous
anxious1437283anxious
avions94114393_avions
bevies114017303bevi_es
bevors111610343bev_ors
bilious9310933bilious
carious93320283carious
cerous85821203ce_rous
cheviots1643783cheviots
copious11311963copious
curious93813563curious
danios7314603danio_s
davies105020513davi_es
davits104012363davi_ts
deacons10310393deacons
deairs74013783deai_rs
debits94214503debi_ts
debtors1038533debtors
decides114217653decides
decidua1144493decidua
deciduas1243463deciduas
deciduous1342613deciduous
deciles104417723deciles
decorous1138853decorous
decors94017773de_cors
decos85522123de_co_s
decoys123911283de_coys
defiers113913993defiers
defies104624053defi_es
defiles114016843defiles
defines114118683defines
defis96717503defi__s
defocus1335283defocus
defogs1156683de_fogs
deices94119373de_ices
deigns8389983de_igns
deils65722863de_i_ls
deisms94411043de_isms
deists74916433de_ists
deixis1437243de_ixis
dekkos1034103dekko_s
delicious1246713delicious
delicts104012253delicts
delimes10314193delimes
delirious1045603delirious
delis64928543deli__s
delists84414173delists
delouse839833de_louse
demies94825803demi_es
demigods1343983demigods
demises103719563demises
demits94918073demi_ts
demobs11429483de_mobs
demons94917723de_mons
demos86022993de_mo_s
denials84114133denials
deniers84515183deniers
denies74729643deni_es
denims95214323deni_ms
depicts12358463depicts
deploys1336523deploys
depots94716343de_pots
derides93420853derides
derives114017813derives
designs9328313designs
desires81316133desires
desists83611723desists
despots10319683despots
deticks1437353deticks
detinue85010033detinue
detinues9569823detinues
detour778193de_tour
detours858043de_tours
detritus945473detritus
devalue1136013devalue
devalues1235853devalues
devas96218883dev__as
deveins1138803deveins
develops14145323develops
devels104313903dev_els
devests114410473devests
deviant11311313deviant
deviants1236733deviants
deviate11312713deviate
deviates12312733deviates
deviators1358533deviators
device124512163devi_ce
devil94714733devi__l
deviled124112183deviled
devilish1546373devilish
devilry1433973devilry
devisal1136913devisal
devisals1245613devisals
devise104215753devi_se
devised123712563devised
devisee113812713devisee
devisees12358283devisees
deviser114212393deviser
devisers12339863devisers
devisor11357043devisor
devoice13347343devoice
devoices14307413devoices
devoid1189363dev_oid
devoir1076033dev_oir
devon95113683dev_o_n
devote104513783dev_ote
devotes113713753devotes
devotions1356593devotions
devs86424033dev___s
dewools1145593dewools
dexies145018343dexi_es
dextrous1646593dextrous
dezincs1933753dezincs
dioecious1244383dioecious
dioicous1145133dioicous
diols65521013d__iols
divides123211453divides
divines113514723divines
divisors12255693divisors
divots104712203div_ots
durions839963durions
duteous838453duteous
dyvour1393343dyv_our
dyvours1453183dyv_ours
edacious1146023edacious
evicts11368553_evicts
evils84114263_evi_ls
evites94916473_evites
ferrous1049793ferrous
feverous1446513feverous
folious103710733folious
furious103110633furious
genius74512923geni_us
haviors1347383haviors
haviour1354823haviour
haviours1443843haviours
heinous1038853heinous
helios94816633helio_s
heriots10312063heriots
impious1137063impious
jealous1438093jealous
kevils13358333kevi_ls
legions84611783legions
leprous938843leprous
lesions73813873lesions
leviers103510343leviers
levies93919863levi_es
levins94514653levi_ns
levis85818553levi__s
medius93613283medi_us
meous76120063me__ous
nervous1037143nervous
nevus84611393nev__us
nimious937663nimious
niveous1037193niveous
noxious1446563noxious
odious749933_odious
osmious936003osmious
paviors1237603paviors
paviour1244623paviour
paviours1343613paviours
perilous10310693perilous
periods10312243periods
peritus9311803peritus
petrous92714423petrous
pious74621273__pious
pluvious1344443pluvious
precious12310593precious
regions83613473regions
regius7311923regi_us
reovirus1143423reovirus
resinous838503resinous
reviews1335533reviews
reviles104421353reviles
revises104220533revises
revisors11379063revisors
revives134715543revives
rubious938283rubious
sanious7514103sanious
saviors1058993saviors
saviour1035213saviour
saviours1154273saviours
seniors73413613seniors
serous65023563se_rous
setous64917373se_tous
simious939803simious
specious1247483specious
tenuous738483tenuous
unenvious1263243unenvious
uveous936603_uveous
various103113103various
venous93713193ve_nous
vicious1239493vicious
vinous93914173__vinous
viols86118103__viols
virus85316843__virus
zealous1637813zealous

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340272176.39020974.5
3Display Results2172170.0762855.3
 (SQL Overall)1786912176.60927037.5
 
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.