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

103 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
pulsation113714(None) 
pulsations1236371pulsations
palmation13310222palmation
palpation1339072palpation
peltation11312962peltation
pulsatile1173392pulsatile
pulsating1236342pulsating
pulsative1455172pulsative
pulsator1085692pulsat_or
pulsion938392puls__ion
pupation1269502pu_pation
purgation1247392purgation
sulcation11710732sulcation
sulfation1288782sulfation
ablation10312433abl_ation
adulation10311013adul_ation
alation72920553_al_ation
cassation1197913cassation
causation1199523causation
cessation1176853cessation
ciliation111112493ciliation
collation11313993collation
copulation141111953copul_ation
delation92318083del_ation
dilation92215463dil_ation
duration9312693du_ration
elation73620453_el_ation
emulation11312393emul_ation
epilation11312963epil_ation
exultation1747533exultation
fellation1238843fellation
filiation121110243filiation
foliation121110793foliation
furcation1448353furcation
gelation93014433gel_ation
gustation1047963gustation
guttation1046173guttation
halation11313853hal_ation
illation8311943_illation
lallation939493lallation
lunation8311923lu_nation
luxation1538233lu_xation
mutation101412883mu_tation
nucleation1245963nucleation
nunnation9126563nunnation
nutation81513103nu_tation
oblation1039863obl_ation
outstation1046163outstation
ovulation1238983ovul_ation
palliation1248503palliation
palmations1438733palmations
palpations1437653palpations
peculation14311993pecul_ation
peltations12311553peltations
phonation1439393phonation
pinnation1138013pinnation
placation1339773placation
planation11310123planation
plastron1046913p_lastron
platoon938953p_l_atoon
plication13311683plication
pollution1146003pollution
population14810023popul_ation
position10912193p_osition
potation101716783p_otation
predation12313463predation
privation14311173privation
probation13412183probation
pronation11415703pronation
proration11415983proration
publication1746573publication
pullulation1343343pullulation
pulsate9510233pulsat__e
pulsated1136853pulsat_ed
pulsates1048813pulsat_es
pulsators1175373pulsators
pulsatory1474613pulsatory
pulsions1037713puls__ions
punctation1486053punctation
punition1038373pu_nition
pupations1338123pu_pations
purgations1346743purgations
question1745823ques_tion
quotation18146973quotation
relation82619773rel_ation
ruination9311273ruination
saltation9312003saltation
salvation1239293salvation
sensation9510583sensation
siltation939213siltation
solation8916153sol_ation
solvation1237773solvation
spallation1247023spallation
spoliation1248423spoliation
sublation11311013sublation
substation1248993substation
sudation9310803su_dation
sulcations1289583sulcations
sulfations13107813sulfations
summation1347803summation
ululation938093_ululation
vallation1239743vallation
valuation1249973valuation

Search took 7 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.440406115.9
2DLD Change Limit1486411036.14024208.6
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.62626968.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.