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

146 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
laagering113683(None) 
lagering102212311l_agering
angering102113802_angering
badgering1436962badgering
daggering13246112daggering
dangering12239302dangering
lackering1639372lackering
laddering1237592laddering
lappering14258842lappering
lathering13912252lathering
laveering1336812laveering
lawyering1655212lawyering
layering122310352l_ayering
leaguering1243812leaguering
lingering11310512lingering
saggering12197792saggering
wagering13219522_wagering
adhering1338883_adhering
ageing84213403__age_ing
algerine9810283_algerine
altering91917113_altering
angeling102811733_angeling
auguring1036383_auguring
bannering12208803bannering
bantering122414233bantering
barbering14229683barbering
bartering122313643bartering
battering122715143battering
beavering1538703beavering
blabbering14104363blabbering
blathering16107583blathering
blattering13108713blattering
buggering1435193buggering
cageling12310843_cageling
cambering16109873cambering
cankering162110793cankering
cantering122417373cantering
capering132414963_capering
careering12311203careering
catering112019903_catering
clabbering17104583clabbering
clambering1776163clambering
clangoring1443913clangoring
clattering13109233clattering
clavering1538373clavering
cratering12312653cratering
dackering1737383dackering
daikering1536103daikering
dandering122511063dandering
diapering1339033diapering
faltering132211113faltering
fathering161010093fathering
fingering1439193fingering
flattering1498743flattering
gandering122111293gandering
garnering11298083garnering
gartering112111573gartering
gathering1499463gathering
gingering1238873gingering
haltering132212003haltering
hammering1737633hammering
hampering1738863hampering
hangaring1438033hangaring
hankering17239383hankering
havering152211053_havering
hungering14187683hungering
jabbering2134443jabbering
jiggering1934303jiggering
kashering1736253kashering
laager74312783laager___
laagered1055853laager_ed
laagers83411253laager__s
labeling11311643l_abeling
laboring112110143l_aboring
labouring1236213labouring
lacewing1435843l_acewing
lackeying1934923lackeying
lacquering2243603lacquering
ladening1078823l_adening
lagging103316733l_ag_ging
lairing83715343l_a_iring
latening9711493l_atening
laughing1335933laug_hing
laundering1245183laundering
laureling1035643laureling
lawgiving1762143lawgiving
lawyerings1752583lawyerings
layerings13235683l_ayerings
leadening1176733leadening
leaguing1035343leag_uing
leathering1488683leathering
leavening1365973leavening
lechering1538443lechering
leering83417643l__eering
lettering102112073lettering
levering122212503l_evering
limbering1488793limbering
lippering14217883lippering
littering102411983littering
livering122012383l_ivering
loitering1039683loitering
longeing10177593longe_ing
loppering14237283loppering
lowering122210913l_owering
lugeing9359113l_uge_ing
lumbering14117933lumbering
lustering102711203lustering
mammering1337333mammering
mastering122315303mastering
mattering122314053mattering
mongering13310353mongering
nattering102212213nattering
palavering1644483palavering
paltering122612893paltering
pampering1638383pampering
pandering133211963pandering
papering132213313_papering
pargeting1338283pargeting
pattering122314423pattering
paupering1437273paupering
plastering1339243plastering
quavering2235953quavering
rogering10310273_rogering
sabering112113743_sabering
saggaring12236243saggaring
slabbering15104973slabbering
slandering1237243slandering
slathering14108283slathering
slavering1338723slavering
staggering13194583staggering
swaggering16233623swaggering
tabering112211423_tabering
tampering1438453tampering
tangerine1048403tangerine
tapering112112503_tapering
targeting1137303targeting
tattering102212323tattering
unageing1036273unage_ing
wafering15208893_wafering
waitering13310713waitering
wandering143310983wandering
watering122316313_watering
wavering152410543_wavering
yabbering1734023yabbering
yammering1735193yammering
yattering132410443yattering

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411467.04621095.8
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.53223724.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.