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 “demies” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
demies9482580(None) 
defies104624051defies
demes86032691dem_es
demise94618321demise
demises103719561demises
demits94918071demits
denies74729641denies
dexies145018341dexies
aeries64737782aeries
amies76837692_amies
armies85123692armies
belies84631052belies
bemires113212832bemires
bemixes18338652bemixes
bevies114017302bevies
dames85435852dam_es
davies105020512davies
deairs74013782deairs
dearies83526272dearies
deaves105319532deaves
debits94214502debits
debyes1238102debyes
decides114217652decides
deciles104417722deciles
decries103319812decries
dees56356632de__es
defied115016382defied
defier105118652defier
defiers113913992defiers
defiles114016842defiles
defines114118682defines
defis96717502defi_s
deices94119372deices
deifies113317452deifies
deils65722862de_ils
deities82621922deities
dekes105224452de_kes
deles65139252de_les
delimes10314192delimes
delis64928542deli_s
dellies83622212dellies
delves104917082delves
deme76536282dem_e_
demic105119192demi_c
demirep1236212demirep
demireps1343992demireps
demised113613682demised
demit84832302demi_t
demobs11429482demobs
demoed103713442demoed
demons94917722demons
demos86022992dem_os
demoses103815832demoses
demotes104717672demotes
demurs939772demurs
denes65639722de_nes
denied84318632denied
denier74420692denier
deniers84515182deniers
denims95214322denims
derbies103016052derbies
derides93420852derides
derives114017812derives
dermis94717162dermi_s
dermises112512022dermises
derries83124622derries
desires81316132desires
desmids1166602desmids
deuces94015512deuces
devices133212582devices
devils104412812devils
devise104215752devise
devises114116762devises
dewier104013462dewier
dewiest11312342dewiest
dexes135224512de_xes
dexie134716892dexie_
didies84621832didies
dies55653532d__ies
dimes85833042dim_es
dobies94422092dobies
dogies85022252dogies
domes85735562dom_es
domines102918972domines
dories75232362dories
doxies143917852doxies
dries64733672d_ries
dummies123012132dummies
duties74921902duties
eddies83313162eddies
emes65434662_em_es
emirs76116162_emirs
emits75421472_emits
enemies9313692enemies
femes105626222fem_es
femmes135410212femmes
genies75324942genies
hemes105031082hem_es
hemins113417572hemins
homies114524732homies
immies102412442immies
jemmies18318332jemmies
levies93919862levies
mamies104626242mamies
memes94927702mem_es
newies91014072newies
premies113823062premies
ramies84630462ramies
relies65036422relies
remiges103015472remiges
remise84221952remise
remises93423482remises
remiss84216352remiss
remits85622942remits
remixes164313872remixes
reties65436192reties
semes75731582sem_es
semis74623532semi_s
semises93916552semises
series64540972series
vegies104314272vegies

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511212.25036689.3
3Display Results1211210.0304033.3
 (SQL Overall)1786911212.62368124.7
 
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.