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

193 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
talented93842(None) 
agented939422_agented
alerted82512222_alerted
galeated104111572galeated
lamented1138192lamented
parented11912212parented
patented1188892patented
relented92614942relented
sklented1335052sklented
tableted1137532table_ted
tabletted1244832tabletted
tainted83512422ta_inted
talent6323322talent__
talents7312012talent_s
taloned8310222talon_ed
taunted84310962ta_unted
telneted935072telneted
tented74221002t__ented
untalented1144842untalented
valeted1139012vale_ted
abetted1058323_abetted
absented1156613absented
accented13107773accented
alated75625143_al_ated
alerter72111513_alerter
alienated1047743_alienated
aliened81011743_alien_ed
alimented1245313_alimented
alined75221403_alin_ed
amended11328313_amended
anted66328243_a__nted
assented957513assented
atlantes838553atlantes
attended1035763attended
attested936293attested
avenged1245503_avenged
averted112211613_averted
balanced1356513balanced
balloted1189043balloted
bleated104015973_bleated
blended114710713_blended
blunted104210663_blunted
cadenced1435523cadenced
calender1138273calender
canted94825783ca__nted
caseated11310713caseated
catenated1238913catenated
caveated1439133caveated
cayenned1443163cayenned
cemented1338373cemented
cleated103417843_cleated
clefted13326753_clefted
daunted93810193da_unted
davened124610073daven_ed
deleted93314913dele_ted
demented12311273demented
dented84120513__dented
elected102812613_elected
faceted13509563face_ted
facetted1445743facetted
fainted114211723fa_inted
falcated1438473falcated
fileted1159093file_ted
flaunted1234603flaunted
fleeted113310233_fleeted
flensed1136613_flensed
flinted114411893_flinted
fomented1437803fomented
galeate83916783galeate_
galenite91210063galenite_
galenites10129183galenites
galette84212693galette_
galettes93111153galettes
gallanted1145893gallanted
galleted1038213galleted
garmented1345883garmented
gazetted19234853gazetted
gleeted9379323_gleeted
glinted9399373_glinted
halted105019603hal__ted
hanted104124313ha__nted
haunted11399733ha_unted
havened14429243haven_ed
hented104218753__hented
incented112412543incented
indented101811733indented
invented122510663invented
isleted837523isle_ted
jaunted15418563ja_unted
ladened979053laden_ed
lamenter1038863lamenter
latened8711923laten_ed
lenited8812433__lenited
lensed74015473__lensed
lenten6312883__lenten
letted74118543__letted
linted74021823__linted
lunted74517523__lunted
maleate94117543maleate_
maleates103316343maleates
malted94819863mal__ted
margented1346813margented
molested11178243molested
oriented937483oriented
painted104214633pa_inted
paleate94120003paleate_
palette93613983palette_
palettes103112833palettes
palleted1139873palleted
palmated132511003palmated
palpated13249763palpated
panted95024823pa__nted
patentee1099943patentee
pileated112711133pileated
planted103516123_planted
pleated103816633_pleated
ranted74324703ra__nted
ravened115012283raven_ed
rented74426593__rented
repented112614983repented
rerented92516163rerented
resented92716963resented
sainted84114243sa_inted
salted74121203sal__ted
saluted84511713sal_uted
scented102811883_scented
selected1159783selected
silenced1136273silenced
silenter838873silenter
slanted83514743_slanted
sleeted83113223_sleeted
splinted11369253splinted
stalemated1344323stalemated
stamened1137633stamen_ed
tabered103311593tabe_red
tailender1044073tailender
tailgated1145133tailgated
talced93811003tal__ced
talcked1446343tal_cked
talentless1042803talentless
talesmen1047013talesmen
taliped1078203tal_iped
talked114015403tal__ked
tallaged10257923tallaged
tallied83314753tal_lied
tallowed12157713tallowed
tanged84622493ta__nged
tanked113919293ta__nked
tanned75219953ta__nned
tapenade1145003tapenade
tapered102612933tape_red
targeted1037483targeted
tarted74923373ta__rted
tasted74123973ta__sted
tatted74920533ta__tted
taunter73111453ta_unter
tauted75317113ta__uted
tautened935423tauten_ed
teated74924023t__eated
telexed1536323tele_xed
telnetted1043813telnetted
tenanted937043tenanted
tended83819483t__ended
tensed74817833t__ensed
tenter64623933t__enter
tested74421523t__ested
threated1259203threated
tilted74616863til__ted
tinted74419533t__inted
toileted936993toile_ted
tokened1236393token_ed
tolerated1049123tolerated
tormented1245963tormented
trabeated1246843trabeated
trajected1944043trajected
treated83618703t_reated
trended94011763t_rended
trientes82812123trientes
truanted935373truanted
tweeted11336583t_weeted
unalerted1047963unalerted
undented102313953undented
unletted9310313unletted
unrented92413923unrented
untented92613413untented
valanced1475463valanced
valence1268773valence_
valences1388513valences
valuated12239203valuated
vaunted11438863va_unted
vented104617923__vented
wakened1546873waken_ed
wanted104319723wa__nted

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.500357382.0
2DLD Change Limit1461621937.40319743.6
3Display Results1931930.0802412.5
 (SQL Overall)1786911937.98322383.9
 
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.