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

144 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
lawyered153403(None) 
layered11259411la_yered
laagered1055852laagered
lackered15108672lackered
laddered1136742laddered
lagered92311152la_gered
lappered13288212lappered
lathered121512322lathered
laveered1235252laveered
lawyer12386972lawyer__
lawyerly1742142lawyerly
lawyers13377152lawyer_s
lowered112711912low_ered
adhered1239233_adhered
altered83215733_altered
angered93013473_angered
badgered1336213badgered
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
blabbered13184593blabbered
blathered15168353blathered
blattered12198563blattered
blazered2035063bla_zered
bowered133113043bow_ered
cambered15128993cambered
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043ca_pered
careered1139493careered
catered103117763ca_tered
clabbered16184753clabbered
clambered16146123clambered
clattered12178403clattered
clavered14187633cla_vered
cowered133214643cow_ered
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
dowered122811553dow_ered
faltered122810983faltered
fathered151510433fathered
flattered13188623flattered
flowered1546013flow_ered
gandered112211173gandered
garnered10247113garnered
gartered10319583gartered
gathered13149373gathered
glaciered1343863glaciered
glandered1236333glandered
glowered1345753glow_ered
haltered123112553haltered
hammered16218843hammered
hampered16239923hampered
hankered16289443hankered
havered144011453ha_vered
hawkeyed2242403hawkeyed
jabbered2034433jabbered
kashered1636403kashered
labeled102510563la_beled
labored102810243la_bored
laboured1156323laboured
lackeyed18104513lackeyed
lacquered2143363lacquered
ladened979053la_dened
laired75216813la__ired
lakebed1434783la_kebed
lanceted1137073lanceted
lanneret82512363lanneret
lanyard1167293lanyar_d
lapeled10258893la_peled
lappeted13255833lappeted
latened8711923la_tened
laterad8310833la_terad
latherer111310443latherer
laundered1185023laundered
laureled934543laureled
lawed96028323law___ed
lawyering1655213lawyering
layed95127383la_y__ed
layer84626473la_yer__
layers93921183la_yer_s
leaguered1143223leaguered
leathered13148713leathered
lechered1437523lechered
leered73816223l__eered
lettered92910783lettered
levered114212303l_evered
limbered13158123limbered
lingered10129643lingered
lippered13287953lippered
littered92511383littered
livered113111633l_ivered
loitered938183loitered
loppered13326753loppered
louvered1244993louvered
lowbred13225363low_bred
lumbered13188233lumbered
lustered92510603lustered
mammered12237653mammered
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
mayweed1634163maywe_ed
nattered92011623nattered
paltered113012483paltered
pampered15229223pampered
pandered121812573pandered
papered122513163pa_pered
pattered112714203pattered
paupered13216933paupered
plastered1288893plastered
powdered15256893powdered
powered132911643pow_ered
raftered1237663raftered
rapiered1136053rapiered
sabered103213023sa_bered
saggered11237553saggered
sawyer12438043sawyer__
sawyers13317533sawyer_s
sewered112911243sew_ered
slabbered14165083slabbered
slandered1137473slandered
slathered13148533slathered
slavered12188033sla_vered
tabered103311593ta_bered
tampered13279463tampered
tapered102612933ta_pered
tattered92011443tattered
towered112911403tow_ered
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wandered132110793wandered
watered113014953wa_tered
wavered142910433wa_vered
yabbered1633963yabbered
yammered16225763yammered
yattered12239533yattered

Search took 8 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.1561145455.1
2DLD Change Limit1461621447.14020470.9
3Display Results1441440.0632285.7
 (SQL Overall)1786911447.35924282.0
 
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.