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

228 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
lathering1391225(None) 
blathering16107581blathering
fathering161010091fathering
gathering1499461gathering
leathering1488681leathering
slathering14108281slathering
adhering1338872_adhering
altering91917112alt_ering
atheling1249202_atheling
battering122715142battering
blattering13108712blattering
blethering16115932blethering
blithering16116122blithering
bothering152210202bothering
catering112019902cat_ering
clattering13109232clattering
dithering1499842dithering
feathering17108792feathering
flattering1498742flattering
gatherings15105272gatherings
kashering1736252kashering
laagering1136832laagering
lackering1639372lackering
laddering1237582laddering
lagering102212312la_gering
lappering14258842lappering
latening9711492lat_ening
lathing114315692lath__ing
laveering1336812laveering
lawyering1655212lawyering
layering122310352la_yering
lechering1538442lechering
lettering102112072lettering
littering102411972littering
mattering122314052mattering
mothering152110182mothering
nattering102212202nattering
pattering122314422pattering
pothering151911282pothering
slithering1496892slithering
tattering102212322tattering
tethering1339132tethering
watering122316312wat_ering
weathering1798352weathering
withering16108802withering
wuthering1697802wuthering
yattering132410442yattering
angering102113803_angering
antheming1587293antheming
ashlering1344153_ashlering
athelings1345113_athelings
attiring939483_attiring
authoring1348583authoring
badgering1436953badgering
bannering12208803bannering
bantering122414233bantering
barbering14229683barbering
bartering122313643bartering
bathing134816243bath__ing
battening12268853battening
bettering122212753bettering
bittering122511983bittering
blabbering14104363blabbering
brothering1646023brothering
butchering1844503butchering
buttering122312523buttering
cacheting1737153cacheting
cambering16109863cambering
cankering162110793cankering
cantering122417373cantering
capering132414963ca_pering
careering12311203careering
cashiering1643783cashiering
cathecting1844833cathecting
chattering16108633chattering
ciphering17217693ciphering
clabbering17104573clabbering
clambering1776153clambering
clavering1538373cla_vering
cluttering13106833cluttering
cohering142413833_cohering
coshering15510023coshering
cratering12312653crat_ering
cyphering20175243cyphering
dackering1737383dackering
daggering13246113daggering
daikering1536103daikering
dandering122511053dandering
dangering12239303dangering
elaterin849903elat_erin_
elaterins9410033elat_erins
entering91920053ent_ering
faltering132211113faltering
fathoming1844693fathoming
fattening13287833fattening
featherings18105363featherings
fettering132310513fettering
flattening14115103flattening
flittering1486503flittering
fluttering14106293fluttering
furthering1744353furthering
gandering122111283gandering
garnering11298083garnering
gartering112111573gartering
gettering112310033gettering
glittering1296003glittering
guttering112410443guttering
hachuring1845123hachuring
haltering132212003haltering
hammering1737623hammering
hampering1738853hampering
hankering17239383hankering
hatcheling1943693hatcheling
havering152211053ha_vering
ingathering16103013ingathering
inhering12913703_inhering
jabbering2134443jabbering
jittering17218413jittering
koshering1735363koshering
labeling11311643la_beling
laboring112110143la_boring
labouring1236213labouring
lacewing1435843la_cewing
lackeying1934923lackeying
lacquering2243603lacquering
ladening1078823la_dening
lairing83715343la__iring
lashing114422893lash__ing
latching143712023lat_ching
latchstring17101963latchstring
lateraling11148803lat_eraling
laterite8716333lat_erite
laterize17613293lat_erize
laterizing2049083lat_erizing
lather95124353lather___
lathered121512323lather_ed
latherer111310443lather_er
latherers12158853latherers
lathers104321883lather__s
lathery133911123lather__y
lathings12469853lath__ings
lathyrism1743193lathyrism
latrine7715123lat__rine
latticing1246063latticing
laundering1245183laundering
laureling1035643laureling
lawyerings1752573lawyerings
layerings13235673la_yerings
leaguering1243813leaguering
leathern11398913leather_n_
leering83417643l__eering
letterings11225993letterings
levering122212503l_evering
lichening1545673lichening
lightering15246113lightering
limbering1488783limbering
lingering11310503lingering
lippering14217873lippering
lithoing1236743lith_oing
livering122012373l_ivering
loathing1247673loath__ing
loitering1039683loitering
loppering14237283loppering
lowering122210913l_owering
lumbering14117933lumbering
lustering102711203lustering
luthern1037653luther_n_
lutherns1136293luther_ns
mammering1337333mammering
mastering122315303mastering
maturing1139953mat_uring
metering112915633met_ering
mitering113015393mit_ering
motherings16255623motherings
murthering1644473murthering
muttering122611323muttering
ochering14219393_ochering
outhearing1438443outhearing
paltering122612893paltering
pampering1638383pampering
pandering133211953pandering
papering132213313pa_pering
partnering1345553partnering
patterning1346073patterning
paupering1437273paupering
petering112516813pet_ering
plastering1339243plastering
pottering122612003pottering
puttering122611643puttering
racheting1537793racheting
ratcheting1643783ratcheting
rattening10288763rattening
regathering1645193regathering
sabering112113743sa_bering
saggering12197793saggering
scattering1398013scattering
shattering1498283shattering
slabbering15104973slabbering
slandering1237243slandering
slavering1338723sla_vering
smattering1397583smattering
smothering1646013smothering
spattering13107793spattering
sphering142811943_sphering
splattering1454543splattering
steering93916793_steering
swithering17105213swithering
syphering18175733syphering
tabering112211423ta_bering
tampering1438453tampering
tapering112112503ta_pering
theming133610473__theming
tiering8315243__tiering
tittering102310303tittering
tochering1537153tochering
tottering10229613tottering
upgathering1842203upgathering
ushering1258923_ushering
uttering91613083_uttering
wafering15208893wa_fering
wagering13219523wa_gering
waitering13310713waitering
wandering143310973wandering
waterings13229243wat_erings
wavering152410543wa_vering
weatherings1895253weatherings
yabbering1734023yabbering
yammering1735193yammering

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486412288.14018260.6
3Display Results2282280.1102072.7
 (SQL Overall)1786912288.42321214.7
 
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.