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

145 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
absented115661(None) 
absentee1067661absentee
absenter1086771absenter
assented957511assented
abetted1058322ab_etted
abseiled1144732abseiled
absence1137692absence_
absences1247672absences
absent84016992absent__
absentees1164532absentees
absenters1156172absenters
absently1345812absently
absents93510722absent_s
accented13107772accented
agented939422a_gented
assenter867702assenter
asserted957902asserted
resented92716962resented
abated95918453ab__ated
abducted1444093abducted
abetter958323ab_etter
ablated102513443ab_lated
abluted10188363ab_luted
abnegated1344163abnegated
aborted10310423ab_orted
abounded1234903abounded
abreacted1444293abreacted
abscessed1442703abscessed
abscised1364133abscised
absconded1543003absconded
absenting1236993absenting
absinth1244973absint_h
absinthe1342643absinthe
absinthes1442673absinthes
absinths1342953absinths
absolved1443133absolved
absorbed1344253absorbed
absterged1353353absterged
abutted1056983ab_utted
accepted15105373accepted
advected1534533advected
adverted1336103adverted
affected1744793affected
alerted82512223a_lerted
alienated1047743alienated
aliened81011743alien_ed
alimented1245313alimented
amended11328303a_mended
amounted1135533amounted
anointed938343anointed
ansated84214003ans_ated
anted66328243a___nted
appended1435483appended
arointed939003arointed
aroynted1244523aroynted
arrested939153arrested
arsenate81010483arsenate_
arsenates979363arsenates
arsenide9116333arsenide
arsenite8119663arsenite_
arsenites9149163arsenites
ascended1246513ascended
assent65119953assent__
assenters966993assenters
assentor865293assentor
assents74512223assent_s
asserter877563asserter
assessed945023assessed
assisted936233assisted
assorted956593assorted
attended1035763attended
attested936293attested
augmented1343833augmented
avenged1245503a_venged
averted112211613a_verted
axseed1456993axse__ed
basined10310003basin_ed
basseted1136743basseted
bassetted1244693bassetted
basted95227233bas__ted
belted94020633_b_elted
bended105521233_b_ended
bested94922753_b_ested
betted94721163_b_etted
bisected1336203bisected
bleated104015973_bleated
blended114710713_blended
blunted104210663_blunted
bunted95219183_b_unted
caseated11310713caseated
cemented1338373cemented
consented12311943consented
demented12311273demented
dented84120513__dented
deserted101012203deserted
dissented1199713dissented
exsected1835673exsected
exserted1636213exserted
fomented1437803fomented
garmented1345883garmented
hented104218753__hented
incented112412543incented
indented101811733indented
inserted92413053inserted
insetted9249023insetted
invented122510663invented
lamented1138193lamented
lisente71210703lisente_
margented1346813margented
misenter10310833misenter
nauseated1045233nauseated
objected2043493objected
observed1444373observed
obsessed1144273obsessed
obtected1344553obtected
obtested1135453obtested
obverted1435103obverted
oriented937483oriented
parented11912213parented
patented1188893patented
presented12311613presented
rabbeted1334443rabbe_ted
relented92614943relented
rented74426593__rented
repented112614983repented
rerented92516163rerented
reseated93220263reseated
resected112514743resected
scented102811883_scented
seated75131053__seated
sended85121233__sended
sensed73918163__sensed
sente56432873__sente_
sklented1335053sklented
tableted1137533table_ted
tabletted1244833tabletted
talented938423talented
tented74221003__tented
undented102313953undented
unrented92413923unrented
unscented1237513unscented
unseated91317683unseated
untented92613413untented
vented104617923__vented
wadsetted1442623wadsetted

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.220812231.8
2DLD Change Limit1461621458.57617043.1
3Display Results1451450.0632301.6
 (SQL Overall)1786911458.85920170.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.