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

135 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
telfered123488(None) 
peltered112510442peltered
pilfered1435852pilfered
teddered11255182teddered
teetered9258302teetered
telexed1536302tel_exed
telfer9379892telfer__
telfers10299072telfer_s
telford1145152telfor_d
telneted935072telneted
telphered1544212telphered
tempered13248212tempered
tendered102510602tendered
tentered96412102tentered
tethered1238492tethered
tillered937432tillered
weltered12238432weltered
altered83215733_altered
beavered1437503beavered
befleaed1454653befleaed
belfried1444203belfried
believed14427923believed
bettered113011833bettered
buffered1764993buffered
cellared11398793cellared
centered112513523centered
coffered1737673coffered
deafened1335853deafened
deferred13106363de_ferred
defleaed1344943defleaed
deflexed2043863deflexed
deleted93314903del_eted
delivered1445033delivered
differed1635523differed
entered82718883_entered
faltered122810983faltered
fendered13258673fendered
festered122512103festered
fettered12259493fettered
fevered14339723fe_vered
filtered12259043filtered
fleered11309503_fleered
fullered1236383fullered
gendered11258873gendered
gettered10258613gettered
goffered1634523goffered
haltered123112553haltered
helmeted1435833helmeted
hollered1237603hollered
interfered1448533interfered
jeered143912793je__ered
lechered1437523lechered
leered73816223__leered
lettered92910783lettered
levered114212303le_vered
membered1535903membered
metered103514013me_tered
moldered1237173moldered
neutered937423neutered
niffered1544143niffered
offered1436143_offered
paltered113012483paltered
peered93819483pe__ered
pelleted1138183pelleted
peppered1236113peppered
pestered112814953pestered
petered103314963pe_tered
pilferer1344923pilferer
realtered1037893realtered
refeed104717623re_fe_ed
referee101615753re_feree
refereed12149693re_fereed
referred1297833re_ferred
refired115116993re_fired
reflexed1975233reflexed
relieved12438513relieved
rendered102512263rendered
reoffered1643313reoffered
revered112819333re_vered
selfed10310913self__ed
severed113513863se_vered
sewered112911243se_wered
sheltered1335573sheltered
silvered12237563silvered
skeltered1443873skeltered
soldered1038153soldered
steamered1244913steamered
steered83615253ste__ered
suffered1536733suffered
sulfured1236113sulfured
sweltered1344453sweltered
tabered103311593t_abered
tafferel1443123tafferel
tampered13279463tampered
tapered102612933t_apered
tattered92011443tattered
teared75722153te__ared
teaseled9186783teaseled
teazeled18194233teazeled
teemed95114873te__emed
telemen9310173tel_emen
teleran7510173tel_eran
teleses7313123tel_eses
telexes1438343tel_exes
telfering1336253telfering
telfords1244343telfords
teller63519813teller__
tellers73717583teller_s
telnetted1043813telnetted
telomere1046433telomere_
telomeres1146363telomeres
temperer12227723temperer
tenderer9228733tenderer
tenured838363te_nured
tepefied1444573tepefied
textured1695483textured
tiered73613973t__iered
timbered13137383timbered
tinkered1387683tinkered
tittered9239493tittered
tochered1437913tochered
tottered9208703tottered
towered112911403t_owered
tuckered1535963tuckered
ulcered1037973_ulcered
veered103612743ve__ered
velured1136683vel_ured
velveret1447043velveret
velveted1533833velveted
veneered1235983veneered
wafered14288433_wafered
welfare1335713welfare_
welfares1445543welfares
westered122511863westered
wildered1336633wildered

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.1731032896.0
2DLD Change Limit1461621358.53017135.1
3Display Results1351350.0462934.8
 (SQL Overall)1786911358.74920424.2
 
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.