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

186 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
deterred1013780(None) 
deferred13106361deferred
deterged11127921deterged
deterrer9137011deterrer
debarred12165632debarred
decerned1237262decerned
deferrer12135592deferrer
degermed1335452degermed
demerged13157602demerged
demurred1234932demurred
depermed1436452depermed
deserted101012202deserted
deserved13108132deserved
detected12289732detected
deterge9118462deterge_
deterger10147592deterger
deterges101510092deterges
deterrent10128942deterrent
deterrers10116592deterrers
detested10279622detested
detoured1036512detoured
interred92615262interred
metered103514012mete_red
petered103314972pete_red
referred1297832referred
undeterred1263832undeterred
altered83215733alte_red
averred11237593_averred
bestirred1243803bestirred
bettered113011833bettered
catered103117773cate_red
centered112513523cente_red
deaerated11311113deaerated
deaired9411533de_aired
debarked16175823debarked
debeaked1634613debeaked
debeard1137353debear_d
debearded1443373debearded
deceased1247713deceased
deceived1535893deceived
decentred13236233decentred
declared1248743declared
decreed112710253de_creed
decried112612853de_cried
decurved1534843decurved
deeded94615543de_e_ded
deemed104713063de_e_med
deerweed1344183de_erweed
defeated132812163defeated
defected15289973defected
defenced1537203defenced
defended1437223defended
defensed1336223defensed
deferral1244353deferral
deferrers13115153deferrers
deforced15247373deforced
deformed15248263deformed
degreed10258883de_greed
dehorned1345683dehorned
dehorted1357303dehorted
dejected19307593dejected
deleaded1148333deleaded
deleaved1346573deleaved
deleted93314913dele_ted
demarked16187223demarked
demeaned1237283demeaned
demented12311273demented
demerge11168023demerge_
demerger12127373demerger
demergered1543173demergered
demerges12129503demerges
demerited1339073demerited
demurrer1144043demurrer
departed1238823departed
depended1337983depended
deplored1237233deplored
deported1249703deported
descried1248073descried
deserter91211603deserter
deserve11108703deserve_
deserver12118383deserver
deserves12109893deserves
desexed1636183dese_xed
desired9311983de_sired
desorbed1236443desorbed
detached1537733detached
detailed10319873detailed
detained103111643detained
detecter11298733detecter
detente83313603detente_
detentes92712873detentes
deter65028043dete_r__
detergent11129573detergent
detergers11147183detergers
determent121312903determent
determined1455823determined
deterrence1345623deterrence
deterrents11126473deterrents
deterring1138623deterring
deters74724683dete_r_s
detester9239683detester
dethroned1445073dethroned
deticked1635693deticked
detoxed1636103det_oxed
detrude936083det_rude
detruded1134883detruded
deuterated1247533deuterated
deuteride1145543deuteride
deveined1336673deveined
develed123611933deve_led
devested13239133devested
devoured1335723devoured
dewatered1444743dewate_red
dewormed15236223dewormed
dithered13189293dithered
diverged14256883diverged
diverted13199583diverted
dogeared1145793dogeared
dowered122811553dowe_red
emerged11158213_emerged
emersed10138513_emersed
entered82718883ente_red
erred65915673___erred
eterne6311723_eterne_
everted112711853_everted
exerted152210053_exerted
festered122512103feste_red
fettered12259493fettered
fevered14339723feve_red
gettered10258613gettered
inferred12248353inferred
interbed112413103interbed
interbred1248743interbred
interned93016653interned
interrex15249823interrex
jeered143912793je_e_red
leered73816223le_e_red
lettered92910783lettered
levered114212303leve_red
metred95315143met__red
mitered103213233mite_red
neutered937423neute_red
peered93819493pe_e_red
peltered112510453pelte_red
pestered112814963peste_red
preferred1555003preferred
recurred1137093recurred
refereed12149693refereed
referrer11136053referrer
regeared1039433regeared
reinterred1145153reinterred
remerged12149173remerged
reperked15177793reperked
reserved121010583reserved
retarded102410753retarded
reteamed1138013reteamed
retested92212533retested
retired84620143ret_ired
retorted9312333retorted
retried84419153ret_ried
returned9459133returned
reverbed14269223reverbed
revered112819333reve_red
reversed122711613reversed
reverted122714713reverted
rezeroed1835993rezeroed
secerned1136103secerned
severed113513863seve_red
sewered112911243sewe_red
starred85013453_starred
steered83615253_steered
stirred8359703_stirred
tarred74720283__tarred
teared75722153__teared
teetered9258303teetered
tentered96412103tente_red
termed94816703__termed
terret63425623__terret
tethered1238493tethered
uttered82712433utte_red
veered103612743ve_e_red
veneered1235983veneered
waterbed1436443waterbed
watered113014953wate_red
weltered12238433welte_red
westered122511863weste_red

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.423422437.4
2DLD Change Limit1461621867.97018339.0
3Display Results1861860.1231512.2
 (SQL Overall)1786911868.51620983.0
 
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.