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

207 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
depleted1225870(None) 
deleted93314901de_leted
deplete103010411deplete_
depleter11298851depleter
depletes112810631depletes
dealated103213602dealated
deflated133412302deflated
defleaed1344942defleaed
deflected1635982deflected
deflexed2043862deflexed
delated93722872de_lated
delete73620702de_lete_
deletes83117932de_letes
departed1238822departed
depicted1437742depicted
depilated1339652depilated
deplaned1238652deplaned
depleters12327532depleters
deplored1237222deplored
deployed1535902deployed
deplumed1434072deplumed
deported1249702deported
deputed114610172dep_uted
duplexed1943122duplexed
pelleted1138182pelleted
replated112817512replated
replete92912982replete_
repletes102812462repletes
befleaed1454653befleaed
belated103520013be_lated
belted94020633be_l_ted
billeted1137643billeted
bulleted1138393bulleted
chapleted1743963chapleted
colleted113011653colleted
completed162810263completed
deadened1137233deadened
deafened1335853deafened
dealate83617843dealate_
dealates92716683dealates
debated113916083de_bated
debited113311623de_bited
debuted11379333de_buted
decanted122310493decanted
declared1248743declared
declawed1545923declawed
declined123910883declined
decocted1437683decocted
decreed112710253decre_ed
deducted1356243deducted
deeded94615543de__eded
deemed104713063de__emed
deepened1235653deepened
defatted1335673defatted
defeated132812163defeated
defected15289973defected
deflate113613943deflate_
deflater123211603deflater
deflates123013943deflates
defueled1374513defueled
deglazed2034953deglazed
degreed10258883degre_ed
degusted1135733degusted
dehorted1357303dehorted
dejected19307593dejected
delate73827753de_late_
delates83526283de_lates
delayed123310763de_layed
delead84112343de_le_ad
deleaded1148333de_leaded
deleaved1346573de_leaved
deled75326543de_l__ed
delegated1238373de_legated
delimed11310723de_limed
delisted10310563delisted
deluded10158763de_luded
deluged10167413de_luged
delved114112753de_l_ved
demasted1238763demasted
demented12311273demented
demitted12288773demitted
demoted114313543de_moted
denoted93512763de_noted
dentated10411703dentated
dented84120513de__nted
depainted1375843depainted
departee1139723departee
depend103510923dep_e_nd
depended1337983depended
depermed1436453depermed
depicter1356853depicter
depilate11311703depilate_
depilates12310923depilates
deplane10311413deplane_
deplanes11311203deplanes
depleting1378193depleting
depletion1256653depletion
depletive1545623depletive
deplore1039483deplore_
deplorer1136343deplorer
deplores1139533deplores
deployer1445633deployer
deplume1255063deplume_
deplumes1334943deplumes
deponed113712873dep_oned
deportee11510353deportee
deporter1169393deporter
deposed113412023dep_osed
deposited1346773deposited
depraved1535543depraved
deprecated1646673deprecated
depredated1544803depredated
depressed1357613depressed
deprived1546463deprived
depurated1338183depurated
depute94512303dep_ute_
deputes104911783dep_utes
derated93623503de_rated
deratted1048403deratted
desalted1038313desalted
deselected1444083deselected
deserted101012203deserted
desexed1636173de_sexed
desisted1039783desisted
desolated1139653desolated
despited1248323despited
detected12289733detected
detested10279623detested
develed123611933de_veled
devested13239133devested
deviated13311043deviated
devoted124111093de_voted
dieted83115493d__ieted
dilated93115823d_ilated
diluted9248933d_iluted
diplexer1844203diplexer
dipnetted1343353dipnetted
docketed16156583docketed
dueted84113593d__ueted
duplexer1842893duplexer
duplexes1844043duplexes
elated74725823_e_lated
elected102812613_e_lected
eluted74915263_e_luted
epilated11310753_epilated
fellated1239563fellated
felted103714653fe_l_ted
ferreted1236323ferreted
fileted1159093_fileted
filleted1236603filleted
galleted1038213galleted
gelated93615633ge_lated
gimleted1243973gimleted
helmeted1435833helmeted
isleted837523_isleted
lappeted13255833lappeted
leafleted1342883leafleted
melted94219063me_l_ted
neglected1354693neglected
palleted1139863palleted
pelted94617753pe_l_ted
peplumed1543013peplumed
peppered1236113peppered
perplexed2143233perplexed
plated95225773__plated
pleated103816633__pleated
reelected1238313reelected
reflated123514293reflated
reflected1547983reflected
reflexed1975233reflexed
related83327573re_lated
relented92614943re_lented
remelted11310153remelted
repasted112611533repasted
repeated113117443repeated
repelled113111573repelled
repented112614983repented
repetend1136223rep_etend
replaced133211393replaced
replanted1248063replanted
replate93420053replate_
replates102919263replates
replayed14248623replayed
replead10399003reple_ad
repleaded1336283repleaded
repled93319773repl__ed
repledged1443603repledged
repletely1443293repletely
replevied1574363replevied
replied103914443repl_ied
replotted1235823replotted
replowed14127563replowed
reported11312703reported
repotted1139283repotted
reputed104613483rep_uted
reslated93517523reslated
secreted1138633secreted
selected1159783se_lected
tableted1137533tableted
telexed1536303te_lexed
telneted935073telneted
toileted936993toileted
undeleted1148063unde_leted
valeted1139013_valeted
velveted1533833velveted
weeted103913793we__eted
welted103715823we_l_ted

Search took 9 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 Filter1786911461620.186960704.3
2DLD Change Limit1461622078.06318127.5
3Display Results2072070.0932225.8
 (SQL Overall)1786912078.34221420.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.