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

136 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
anointing103862(None) 
arointing1049361arointing
amounting1236642amounting
appointing1545322appointing
aroynting1344632aroynting
jointing16248612_jointing
pointing112813682_pointing
reanointing1244992reanointing
unjointing1843962unjointing
abominating1644843abominating
aborning1188003aborn_ing
aborting11710253abo_rting
abounding1335193abounding
absenting1236993absenting
accenting1487823accenting
accounting1544923accounting
addicting1485073addicting
adjoining1844033adjoin_ing
admitting1345033admitting
adopting1237453ado_pting
adorning1087323adorn_ing
agenting1039383a_genting
agisting1038243a_gisting
agonising1146573agonising
agonizing2047143agonizing
airting83616303a__irting
alining81917043a_lin_ing
andantini1044563andantini
andantino1044893andantino
animating12312503animating
annotating1146233annotating
announcing1342993announcing
anodizing2046873anodizing
anoint6423633anoint___
anointed938343anoint_ed
anointer837823anoint_er
anointers937003anointers
anointment1256463anointment
anoints7311063anoint__s
antiaging1149673antiaging
anticking1649243anticking
anticling12310693anticling
antidoting1247163antidoting
antihunting1573933antihunting
antiking13412073anti_king
anting75827023a___nting
antiquing1947303antiquing
anviling1239743anvi_ling
anvilling1336833anvilling
assenting1038163assenting
assisting1046183assisting
atoning83514873ato_n_ing
attainting1144783attainting
auditing1039033audi_ting
aviating12311013a_viating
avoiding1336783avoi_ding
awaiting1238273awai_ting
boinking15378423_boinking
canonising1346583canonising
canonizing2247713canonizing
coining103920543_coin_ing
counting113115273_counting
dinting93520553__dinting
eloining9310443eloin_ing
enditing10311073endi_ting
engining1039293engin_ing
enjoining1745053enjoin_ing
enlisting1038343enlisting
enouncing1245583enouncing
enwinding1444933enwinding
fainting123312163_fainting
feinting123410833_feinting
flinting123412343_flinting
foining113013453_foin_ing
foisting122910503_foisting
fronting12310443fro_nting
glinting103210053_glinting
groining102310633groin_ing
hinting113919223__hinting
hoisting123610903_hoisting
incanting1289903incanting
incenting12912063incenting
inciting11312533inci_ting
indenting11911263indenting
indicting1339613indicting
inditing10312113indi_ting
insisting1038823insisting
inventing13109973inventing
inviting1239733invi_ting
inwinding1445173inwinding
joining153011483_join_ing
joisting16328503_joisting
knitting13257023kn_itting
knotting13236573kno_tting
knouting13226793kno_uting
lancinating1445443lancinating
linting83820983__linting
minting103020813__minting
mounting112711813_mounting
noising83615173_noi_sing
nominating1349503_nominating
nooning83014853_noon_ing
notating92513343_notating
noting74120153_no__ting
oinking123714713__oinking
painting113614423_painting
pinpointing1643103pinpointing
poinding122510003_poinding
printing113216083_printing
quoining1835893quoin_ing
quoiting1836093quoi_ting
reminting122315103reminting
retinting102215253retinting
sainting93215733_sainting
snooting92813203sno_oting
snorting92613373sno_rting
snouting92511923sno_uting
splinting1238193splinting
sprinting12310033sprinting
squinting1936223squinting
stinting93415743_stinting
tainting93613583_tainting
tinting84620603__tinting
toiting83217093_toi_ting
unbinding1336513unbinding
unfitting1336423unfitting
unhinging1436093unhinging
uniting8315823un_i_ting
unkinking1334783unkinking
unlinking1436273unlinking
unpinning1245623unpinning
unstinting1147303unstinting
unwinding1435843unwinding
unwinking1735073unwinking
unwitting1335583unwitting
wonting113214103_wo_nting

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.1531167915.0
2DLD Change Limit1486411367.42320024.4
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.63923391.9
 
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.