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

165 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
laagered105585(None) 
lagered92311151l_agered
angered93013472_angered
badgered1336212badgered
daggered12246402daggered
dangered11248512dangered
laager74312782laager__
laagers83411252laager_s
lackered15108682lackered
laddered1136742laddered
lappered13288212lappered
lathered121512332lathered
laveered1235252laveered
lawyered1534032lawyered
layered11259412l_ayered
leaguered1143222leaguered
lingered10129642lingered
saggered11237552saggered
wagered12299332_wagered
adhered1239233_adhered
agreed84712503__agreed
altered83215743_altered
angeled93211513_angeled
augured987193_augured
bannered11299323bannered
bantered113313633bantered
barbered13259543barbered
bartered113113013bartered
battered113315053battered
beavered1437503beavered
blabbered13184593blabbered
blathered15168363blathered
blattered12198573blattered
blazered2035063blazered
buggered1335623buggered
cambered15129003cambered
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043_capered
careered1139493careered
catered103117773_catered
clabbered16184763clabbered
clambered16146133clambered
clangored1343663clangored
clattered12178413clattered
clavered14187633clavered
cratered1149683cratered
dackered16116893dackered
daikered1495223daikered
dandered112110963dandered
diapered1238003diapered
eagerer8248823_eagerer
etagere836533etagere_
etageres936863etageres
faltered122810993faltered
fathered151510433fathered
fingered13128333fingered
flattered13188633flattered
gandered112211173gandered
garnered10247113garnered
gartered10319593gartered
gathered13149383gathered
gingered11127743gingered
glaciered1343883glaciered
glandered1236343glandered
haltered123112563haltered
hammered16218853hammered
hampered16239933hampered
hangared1337573hangared
hankered16289443hankered
havered144011453_havered
hungered13217053hungered
jabbered2034433jabbered
jiggered1834203jiggered
kashered1636403kashered
laagering1136833laagering
labeled102510563l_abeled
labored102810253l_abored
laboured1156333laboured
lackeyed18104513lackeyed
lacquered2143373lacquered
ladened979053l_adened
lagend838743l_age_nd
lager65132863l_ager__
lagers74826143l_ager_s
laggard10347623laggar_d
lagged95520133l_ag_ged
lagger85919833lagger__
laggers94216243lagger_s
laired75216813l_a_ired
lakebed1434783l_akebed
lanceted1137073lanceted
langrel8107033lang_rel
lanneret82512363lanneret
lapeled10258893l_apeled
lappeted13255833lappeted
larger74417513larger__
latened8711923l_atened
laterad8310843l_aterad
latherer111310453latherer
laughed1235893laug_hed
laundered1185023laundered
laureled934543laureled
leadened1036153leadened
leagued935463leag_ued
leathered13148713leathered
leavened1235553leavened
lechered1437523lechered
leered73816223l__eered
lettered92910783lettered
levered114212303l_evered
limbered13158123limbered
lingerer9118303lingerer
lippered13287953lippered
littered92511383littered
livered113111633l_ivered
loitered938183loitered
loppered13326753loppered
louvered1244993louvered
lowered112711913l_owered
lumbered13188233lumbered
lustered92510603lustered
mammered12237653mammered
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
mongered1238953mongered
nattered92011623nattered
palavered1543933palavered
paltered113012493paltered
pampered15229233pampered
pandered121812573pandered
papered122513173_papered
pargeted1238683pargeted
pattered112714203pattered
paupered13216943paupered
plastered1288903plastered
quavered2144813quavered
raftered1237663raftered
rapiered1136053rapiered
rogered939553_rogered
sabered103213023_sabered
saggared11326063saggared
slabbered14165083slabbered
slandered1137473slandered
slathered13148553slathered
slavered12188033slavered
staggered1244473staggered
swaggered1543193swaggered
tabered103311593_tabered
tampered13279463tampered
tapered102612933_tapered
targeted1037483targeted
tattered92011443tattered
unagreed1036823unagreed
wafered14288433_wafered
wagerer11328493_wagerer
waitered1238753waitered
wandered132110793wandered
watered113014953_watered
wavered142910433_wavered
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.440406115.9
2DLD Change Limit1461621656.68621860.9
3Display Results1651650.0632619.0
 (SQL Overall)1786911657.18924856.2
 
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.