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

140 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
pulsating123634(None) 
palpating1438532palpating
plating103823072p_l_ating
pleating112916052p_leating
pulsatile1173392pulsatile
pulsation1137142pulsation
pulsations1236372pulsations
pulsative1455172pulsative
pulsing103712862puls__ing
pupating1337682pu_pating
sulfating1338062sulfating
ablating11311993abl_ating
adulating1178713adul_ating
balsaming1445123balsaming
blasting114013423_blasting
bleating113514503_bleating
bloating113512813_bloating
bulleting1236643bulleting
bursting1138703burs_ting
busting104221793bu_s_ting
cleating113518133_cleating
collating12312763collating
copulating1549373copul_ating
curating11314293cu_rating
delating103119603del_ating
dilating102714903dil_ating
dusting93618993du_s_ting
elating83423083_el_ating
emulating1239873emul_ating
epilating12310963epil_ating
fellating1339243fellating
filiating1339243filiating
floating123111883_floating
foliating1339253foliating
furcating1537783furcating
gelating103015733gel_ating
gloating102611463_gloating
guesting1058463gues_ting
gusseting1173963gusseting
gusting93917163gu_s_ting
justing153615163ju_s_ting
lasting84725243__lasting
lusting83619323lu_s_ting
luxating1645613lu_xating
mulcting13246983mul_cting
musting103221073mu_s_ting
mutating112211753mu_tating
nucleating1346933nucleating
nutating92411953nu_tating
ousting84021353ou_s_ting
outdating11810863outdating
outeating10814493outeating
outlasting1137513outlasting
outrating10916403outrating
outsaying1338703outsaying
outskating1536853outskating
outstating1139363outstating
ovulating1336953ovul_ating
palatine10316063pal_atine
palisading1443893palisading
palleting1238733palleting
palliating1347883palliating
palsying1436233pals_ying
passaging1345613passaging
pasting103826553p_as_ting
peculating1549153pecul_ating
pelleting1237953pelleting
pelting102917273pel__ting
phonating1537813phonating
pillaging1345553pillaging
pillaring1237643pillaring
piloting1139693pil_oting
pirating11314513p_irating
placating1438513placating
placing123815283p_l_acing
plaiting113113513p_laiting
planing103418253p_l_aning
planting113515383p_lanting
plashing143311063p_lashing
platina94413643p_l_atina
platings113611363p_l_atings
platting114813033p_latting
playing133816093p_l_aying
pleading123011443p_leading
pleasing112611593p_leasing
plotting113011013p_lotting
poleaxing1944873poleaxing
polkaing1534633polka_ing
polluting1235703polluting
populating1547663popul_ating
positing11312303p_ositing
posting105622243p_os_ting
prating103424453p__rating
predating13514653predating
presaging1339393presaging
probating14311183probating
pronating12313763pronating
prorating12314283prorating
puling93621403pul___ing
pulling103821073pul__ling
pullulating1442953pullulating
pulping123612323pul__ping
pulsant9310563pulsa__nt
pulsate9510233pulsat__e
pulsated1136853pulsat_ed
pulsates1048813pulsat_es
pulsator1085693pulsat_or
pulsators1175373pulsators
pulsatory1474613pulsatory
punting103318443pu__nting
pursing103715553purs__ing
pursuing1146233purs_uing
pushing133615453pu_s_hing
putting103218573pu__tting
questing1838273ques_ting
relating92725443rel_ating
reslating102516993reslating
ruinating1039593ruinating
russeting1065323russeting
rusting83821263ru_s_ting
sating74735453___sating
sensating1039253sensating
slating83724653_sl_ating
solating9315593sol_ating
solvating1336443solvating
spoliating1366963spoliating
sublating12310983sublating
sulphating1644323sulphating
summating1437943summating
ululating1036643_ululating
unsaying1288153_unsaying
unseating10713203_unseating
unstating10711213_unstating
upcasting1434823upcasting
updating1236593_updating
upleaping1434363upleaping
uplifting1534963uplifting
uploading1334663uploading
uprating11311113_uprating
valuating1338643valuating

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.1561145455.1
2DLD Change Limit1486411407.03021143.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.23224708.4
 
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.