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

158 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
teachings1529655(None) 
teaching143612601teaching_
beaching164114142beaching_
etchings14396292_etchings
leaching143012832leaching_
peaching163613642peaching_
reaching143317202reaching_
teethings1344232teethings
thatchings1942482thatchings
tracings112910412trac_ings
trackings16247542trackings
aching126521973__aching_
actings104512463__actings
archings14499863_archings
attaching1545433attaching_
baching156017753_baching_
backings174012213_backings
bashings144311243_bashings
beadings123711783bea_dings
bearings113912253bea_rings
beastings12387653beastings
beatings114113233bea_tings
belching16349153belching_
benching163411343benching_
blackings18316763blackings
bleaching17287093bleaching_
bracings13369293brac_ings
breaching17269403breaching_
breathings16234313breathings
breechings18273723breechings
caching156317503_caching_
coaching164011963coaching_
couchings17285763couchings
crackings18346843crackings
dealings103510703dea_lings
deashing134210953deashing_
deckings16346683de_ckings
detaching1637263detaching_
eanlings9128473_eanlings
earings84517713_ea_rings
earnings9419333_earnings
earrings9299633_earrings
eastings93412953_eastings
eatings84616443_ea_tings
eching126315563_e_ching_
echinus1236203_e_chinus
etching134511843_etching_
facings134511263_fac_ings
fencings14225663fenc_ings
fetching17298413fetching_
flashings16316663flashings
fletchings19282863fletchings
gearings10359503gea_rings
hatchings18225673hatchings
headings133510493hea_dings
hearings123611853hea_rings
itchings14386193_itchings
kachinas1736343_kachinas
lacings105013653_lac_ings
lashings124412253_lashings
lathings12469853_lathings
leadings103511243lea_dings
leanings94010183lea_nings
learnings1094323learnings
leashing123310313leashing_
leasings9379843lea_sings
leavings12407493lea_vings
leching134613653le_ching_
leeching14318373leeching_
letching143810263letching_
loathings1344213loathings
lynchings18233503lynchings
machines15312893_machines
meanings11329163mea_nings
naethings1343873naethings
neckings15346113ne_ckings
packings174310063_packings
peacing124117073peac_ing_
peching154513903pe_ching_
perching163711633perching_
pleaching17257083pleaching_
poaching163510833poaching_
preaching172811163preaching_
racings105015133_rac_ings
reacting113317893reacting_
readings103512643rea_dings
retching143412173retching_
reteaching1636023reteaching_
roaching143210433roaching_
ruchings14287073_ruchings
sackings15389633_sackings
sacrings11278923_sacrings
searching1538343searching_
seatings93614303sea_tings
sheathings1743913sheathings
slashings13316203slashings
spacings13287043spac_ings
steadings11307083stea_dings
stealings10318853stea_lings
tachinid1446243t_achinid
tachinids1544043t_achinids
tachisms1567143t_achisms
tachists1348183t_achists
tacking144421483t_acking_
tacklings16235853t_acklings
tacrines10310563t_acrines
tahinis1048013t_a_hinis
tailings93211673t_ailings
takings124512573t_a_kings
talkings13358403t_alkings
tannings9268633t_annings
tappings13267713t_appings
tattings9408823t_attings
teachers133212393teach_ers
teaches122718353teach__es
teaming103917593tea_ming_
tearing84021493tea_ring_
teasing83918513tea_sing_
teazling1856573teazling_
techies12513603te_chi_es
technics1585463te_chnics
technos1236183te_ch_nos
teething1237163teething_
tetchiness1543583tetchiness
thacking183110043thacking_
thatching1835143thatching_
things104914303t___hings
thrashings1742783thrashings
tickings15368583t_ickings
tithings12327693t_ithings
torching142510083torching_
touching143211343touching_
trachling1537823trachling_
tracing103720153trac_ing_
tracking153715463tracking_
trainings10246723trainings
trappings14265753trappings
trashing122613223trashing_
trenching15227653trenching_
trichinas1446043trichinas
trithings13246603trithings
truckings16235023truckings
unteaching1645493unteaching_
vetchlings1951703vetchlings
washings15419273_washings
weaklings1794003weaklings
weanlings1394413weanlings
welching17287363welching_
wenching17328863wenching_
witchings18325303witchings
yachtings1842663_yachtings
yealings12257703yea_lings
yeanlings1393693yeanlings
yearlings1384203yearlings
yearnings1393553yearnings
zecchinos2541723zecchinos
zecchins2443533zecchin_s
zechins21137123ze_chin_s

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 Limit1486411586.70322175.3
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.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.