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

242 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
haltering13221200(None) 
altering91917111_altering
faltering132211111faltering
paltering122612891paltering
bantering122414232bantering
bartering122313642bartering
battering122715142battering
cantering122417372cantering
catering112019902ca_tering
chaptering18107962chaptering
chartering16109252chartering
chattering16108642chattering
filtering13199722filtering
gartering112111572gartering
halting114419072halt__ing
hammering1737632hammering
hampering1738862hampering
hankering17239382hankering
hastening13259482hastening
havering152211052ha_vering
hollering1337742hollering
holstering1447082holstering
mastering122315302mastering
mattering122314052mattering
nattering102212212nattering
pattering122314422pattering
peltering122011672peltering
philtering1646252philtering
realtering1139472realtering
shattering1498282shattering
sheltering1446492sheltering
tattering102212322tattering
waitering13310712waitering
watering122316312wa_tering
weltering13219492weltering
yattering132410442yattering
adhering1338883_adhering
alerting91312383_al_erting
algerine9810283_algerine
aliening91510893_aliening
alleging1038473_alleging
alluring939073_alluring
alterant8614963_alterant
alterity1149843_alterity
angering102113803_angering
anteing8312813_ante_ing
attiring939483_attiring
bacterin12410273bacterin_
bacterins13410643bacterins
badgering1436963badgering
ballerina1146483ballerina
bannering12208803bannering
barbering14229683barbering
battening12268853battening
bettering122212753bettering
bittering122511993bittering
blathering16107583blathering
blattering13108713blattering
bolstering1346883bolstering
buttering122312523buttering
calipering1545003calipering
cambering16109873cambering
cankering162110793cankering
capering132414963ca_pering
capturing1436623capturing
careering12311203careering
centering122915143centering
chaffering22104643chaffering
chambering20116043chambering
chamfering21125333chamfering
chastening1656523chastening
chittering16107183chittering
chuntering1647803chuntering
clattering13109233clattering
clavering1538373clavering
cratering12312653cratering
culturing1236553culturing
dackering1737383dackering
daggering13246113daggering
daikering1536103daikering
dandering122511063dandering
dangering12239303dangering
elaterin849903elaterin_
elaterins9410033elaterins
entering91920053_entering
factoring1537533factoring
falteringly1843153falteringly
fastening13268603fastening
fathering161010093fathering
fattening13287833fattening
festering132413173festering
fettering132310513fettering
flattering1498743flattering
fleering123811283_fleering
fostering132411263fostering
fullering1336653fullering
gallerying1543033gallerying
galleting1137633galleting
gandering122111293gandering
garnering11298083garnering
gathering1499463gathering
gettering112310033gettering
guttering112410443guttering
hachuring1845123hachuring
haeing104118923ha__e_ing
hafting144014173haft__ing
haling104229783hal___ing
halloaing1387033halloaing
halloing121510073hal_loing
hallooing1366343hallooing
hallowing1676943hallowing
haloing113814133hal__oing
halter94420883halter___
haltere103614713halter__e
haltered123112563halter_ed
halteres113414603halter_es
halters104619803halter__s
halving143511543hal__ving
hamstring1546003hamstring
hangaring1438033hangaring
hankerings18244753hankerings
hanseling1338063hanseling
hanting114124483hant__ing
happening1735593happening
harboring1538263harboring
hardening1438023hardening
haring104233003ha___ring
harkening1746923harkening
hasting114725193hast__ing
hatching173312213ha_tching
hating104929713ha_t__ing
hatteria1137863hatteri_a
hatterias1258743hatterias
hatting113920233ha_t_ting
havening15258553ha_vening
heartening1446733heartening
hectoring1538303hectoring
helmeting1545503helmeting
hilting113316893hilt__ing
hindering14310273hindering
homering141512073h_omering
hoovering1635753hoovering
hosteling1337893hosteling
hovering151911143h_overing
hungering14187683hungering
hunkering17227123hunkering
jabbering2134443jabbering
jittering17218423jittering
kashering1736253kashering
laagering1136833laagering
lackering1639373lackering
laddering1237593laddering
lagering102212313la_gering
lappering14258843lappering
latening9711493la_tening
lathering13912253lathering
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
leering83417643__leering
lettering102112073lettering
littering102411983littering
loitering1039683loitering
lustering102711203lustering
malting103219083malt__ing
mammering1337333mammering
martyring1535783martyring
maturing1139963ma_turing
metering112915633_metering
misaltering1445123misaltering
mitering113015403_mitering
moldering1367863moldering
mustering122212333mustering
muttering122611323muttering
neutering1038963neutering
oystering1337563oystering
palavering1644483palavering
palleting1238743palleting
pampering1638383pampering
pandering133211963pandering
papering132213313pa_pering
partnering1345553partnering
pastoring12310853pastoring
pasturing1238433pasturing
patterning1346073patterning
paupering1437273paupering
pestering122315663pestering
petering112516813_petering
philtring1544173philt_ring
pilfering1536393pilfering
plastering1339243plastering
portering122012303portering
pottering122612003pottering
prealtering1446173prealtering
puttering122611643puttering
quartering2045843quartering
rapturing1245363rapturing
rattening10288763rattening
sabering112113743sa_bering
saggering12197793saggering
saltern74010653salter_n_
salterns8388903salter_ns
salting84120793salt__ing
sauntering1137223sauntering
sauteing937913saute_ing
scattering1398013scattering
shuttering1496563shuttering
silvering1337923silvering
sintering101014803sintering
sistering101213753sistering
skeltering1545003skeltering
slathering14108283slathering
slavering1338723slavering
smattering1397583smattering
soldering1169033soldering
spattering13107793spattering
sweltering1445233sweltering
tabering112211423ta_bering
tampering1438453tampering
tapering112112503ta_pering
tautening1035843tautening
teetering10239893teetering
telfering1336253telfering
tentering102313203tentering
tillering1037883tillering
tittering102310313tittering
tottering10229613tottering
ulcering1139333_ulcering
unfaltering1543263unfaltering
uttering91613083_uttering
valeting1238853val_eting
wafering15208893wa_fering
wagering13219523wa_gering
waltzing2134263walt_zing
wandering143310983wandering
waterings13229253wa_terings
wavering152410543wa_vering
westering132112643westering
wildering1456743wildering
wintering13412363wintering
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.453394461.4
2DLD Change Limit1486412427.84318952.1
3Display Results2422420.1102200.0
 (SQL Overall)1786912428.40621257.6
 
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.