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 “approbating” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
approbating184458(None) 
approbation1755022approbation
approbations1854242approbations
probating14311192__probating
reprobating1647102reprobating
abrogating1497983a_brogating
acerbating1546293acer_bating
apocopating1853243apocopating
appointing1545323app_ointing
appreciating1954093appreciating
approaching2162453approaching
approbate1546563approbat__e
approbated1744763approbat_ed
approbates1645853approbat_es
approbatory2062893approbatory
appropriating1783493appropriating
approving1745053appro__ving
approximating2761803approximating
arrogating121778393a_rrogating
perorating13313133_perorating
pronating12313763__pronating
prorating12314283__prorating
abating10413974a____bating
acrobatic1587734a_crobati_c
acrobatics16105294a_crobatics
advocating1744484a_dvocating
aerating92821004a_er__ating
aerobatic1399004a_erobati_c
aerobatics1465814a_erobatics
aerobraking1852834a_erobraking
affricating2043964affricating
affronting1742604affro_nting
aggravating1752414aggravating
aggregating1343584aggregating
allocating1347384a_llocating
alphabeting1962264alphabeting
amputating1545104amp_utating
annotating1146234a_nnotating
appealing1446494app__ealing
appearing1436894app__earing
appeasing1446344app__easing
apposing1337404app_o__sing
appraising1545764appr_aising
apprising1447964appr__ising
apprizing2347194appr__izing
aproning11311794a_pro__ning
arointing1049364a__rointing
aroynting1344634a__roynting
asperating1349564asp_erating
aspirating1348364asp_irating
attributing1453134attributing
automating1389304a_utomating
autorotating1373844autorotating
bromating1439184__bromating
camphorating2252564camphorating
cohobating1845024_cohobating
coronating13410174_coronating
corotating1349324_corotating
deprecating1777284deprecating
depredating1655694depredating
derogating1348634_derogating
embrocating1844144embrocating
imprecating1844904imprecating
nonrotating1246304nonrotating
operating12313724oper__ating
oppilating1544864opp_ilating
parbaking1877204_par_baking
parroting1239154parro__ting
patriating13510204patr_iating
percolating1657324_percolating
perforating1747024_perforating
permeating1539924_permeating
personating1447674_personating
phonating1537814__phonating
pirating11314514_pir__ating
prating103424454__pr__ating
prebaking1838064__prebaking
predating13514654__predating
probang12278384__proba__ng
probation13412184__probation
probations14311084__probations
probative1649174__probative
probing123314444__prob__ing
profaning1537294__profaning
profiting1549984__profiting
promoting1439924__promoting
prompting1637204__prompting
prorogating1556064prorogating
rebating112418344___rebating
reprobation1548504reprobation
reprobations1647774reprobations
reprobative1855644reprobative
reprobing1438074reprob__ing
rotating92614554___rotating
sporulating1445114sporulating
sprouting1236944_spro_uting
subrogating15164984subrogating
surrogating13194324surrogating
throating1398404_thro_ating
uppropping1352564uppro_pping
uprating11311114_upr__ating
uprooting1276904_upro_oting

Search took 10 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 Filter1786911488190.406440125.6
2DLD Change Limit1488191028.56317379.3
3Display Results1021020.0631619.0
 (SQL Overall)1786911029.03219784.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.