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

165 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
sweetie1015787(None) 
sweeties11159721sweeties
seethe93712482s_eethe
sheenie10159492sheenie
sheltie10109912sheltie
sleetier837882sleetier
steelie7310212steelie
sweatier1147032sweatier
sweenies11148762sweenies
sweepier1355492sweepier
sweet85330522sweet__
sweeten10267312sweeten
sweeter103212002sweeter
sweeting123911312sweeting
sweetish1445372sweetish
sweetly1335592sweetly
sweets94214432sweet_s
weenie92612022_weenie
weepie11258792_weepie
beetle8311673_beetle
bheestie1343153bheestie
creepie1137483creepie
dweebier1442223dweebier
eerie55228533__eerie
freebie1236043freebie
gleetier934913gleetier
greenie8310123greenie
peerie83617893_peerie
preemie11310563preemie
retie55735303__retie
safetied1244663safetied
safeties1139163safeties
saltie63422433s_altie
sceptic1337833sceptic
sceptre1135053sceptre
scottie937463scottie
sectile9311973s_ectile
seedier83513633s_eedier
seedtime1144183seedtime
seepier92912013s_eepier
seethed113410193s_eethed
seethes103613743s_eethes
selkie102811693s_elkie
sente56432883s_ent_e
senti56226703s_enti_
septic102713193s_eptic
septime1138803s_eptime
sestine73017923s_estine
setae56026223s__etae
settee63721023s_ettee
settle63915663s_ettle
sextile1438573s_extile
sheathe1348993sheathe
sheenier11167423sheenier
sheenies111411543sheenies
sheet84836963sheet__
sheeted113813043sheeted
sheeter103814913sheeter
sheetfed1544143sheetfed
sheeting122712833sheeting
sheetlike1644333sheetlike
sheets93918503sheet_s
sheeve123412843shee_ve
shelties111111383shelties
shortie10411343shortie
sienite7312713sienite
skeet95429183skeet__
skeeter113410413skeeter
skeets104513253skeet_s
skeptic1545203skeptic
sleekier1245573sleekier
sleekit1145453sleekit
sleepier1036783sleepier
sleet55639133sleet__
sleeted83113223sleeted
sleetiest938553sleetiest
sleeting93114163sleeting
sleets64318873sleet_s
sleety94112653sleet_y
sleeve93411593slee_ve
smartie9310173smartie
smectic1336613smectic
smectite1245773smectite
sneerier878103sneerier
sneeze15318523snee_ze
sneezier1774333sneezier
softie93312483s_oftie
sometime1246753sometime
sortie63621993s_ortie
specie10412223s_pecie
spectre11297773spectre
speedier1146623speedier
steatite8310583steatite
steelier839183steelier
steelies8312553steelies
steeple937323steeple
steeve93710903stee_ve
strette7310763strette
sureties8316583sureties
svelte9319753svelt_e
swabbie1484333swabbie
swaggie12135783swaggie
swathe125514113sw_athe
sweat85628403sweat__
sweated113411543sweated
sweater103712723sweater
sweatiest1238413sweatiest
sweatily1435473sweatily
sweating123213023sweating
sweats94814613sweat_s
sweaty123710053sweat_y
swede94413203sw_e_de
sweeney13387003sweeney
sweeny12358843swee_ny
sweep104715723swee__p
sweeper12329373sweeper
sweepiest1435673sweepiest
sweeping14389143sweeping
sweeps114110513swee_ps
sweepy14447453swee_py
sweer84918573swee__r
sweetbrier1551803sweetbrier
sweetened1343253sweetened
sweetener1243403sweetener
sweetens11255433sweetens
sweetest1137173sweetest
sweetings13326183sweetings
sweetmeat1442823sweetmeat
sweetness1245683sweetness
sweetsop1341893sweetsop
swelter103711173swelter
sweltrier1242993sweltrier
sweltry1333413sweltry
swept105720603swept__
swerve1256293sw_erve
swithe124010683sw_ithe
syenite1039773syenite
syrette1037183syrette
teethe94511313_teethe
tentie62521183_tentie
tweedier1253623tweedier
tweedle1134193tweedle
tweenies11146393tweenies
tweet84823983tweet__
tweeted11336583tweeted
tweeter10288533tweeter
tweeting12267033tweeting
tweets94210103tweet_s
tweeze18265473twee_ze
twenties1137503twenties
wedgie11428373_wedgie
weedier113810623_weedier
weenier103210803_weenier
weenies102915093_weenies
weepier12319273_weepier
weepies122811743_weepies
weet75254153_weet__
weeted103913793_weeted
weeting113816053_weeting
weets85427723_weet_s
weevil1295433_weevil
weewee12310083_weewee
wellie92814913_wellie
wheelie1336193wheelie
wienie9229973_wienie

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.393454684.5
2DLD Change Limit1340271655.81023068.3
3Display Results1651650.0632619.0
 (SQL Overall)1786911656.26628517.6
 
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.