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

124 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
probations1431108(None) 
probation13412181probation_
pronations12314031pronations
prorations12314461prorations
approbations1854242approbations
lobations11219612_lobations
perorations13314062perorations
phonations1538312phonations
potations111615072p_otations
predations13812152predations
privations15310102privations
proactions1449342proactions
probating14311192probati_ng
probational1547082probational
probationer1563772probationer
probationers1662572probationers
promotions1448782promotions
pronation11415702pronation_
proration11415982proration_
reprobations1647772reprobations
rogations101510822_rogations
rotations91613842_rotations
abrogations14116473abrogations
adorations11310243adorations
approbation1755023approbation_
arcuations1249343arcuations
arrogations12126483arrogations
avocations15168683avocations
conations111318903_conations
coronations13410703coronations
corotations1349773corotations
creations112614543cr_eations
cremations14410713cremations
crenations12511693crenations
derogations1349393derogations
donations101112353_donations
dotations101411633_dotations
evocations15259873evocations
flotations1366873flotations
formations1538203formations
gradations1286863gradations
iodations1039113_iodations
isolations10310693isolations
libations112510443_libations
lobation102110553_lobation_
locations112512743_locations
notations91512973_notations
novations12139003_novations
oblations1139373__oblations
orations81515803__orations
ovations11149263__ovations
ozonations1945143ozonations
palmations1438733palmations
palpations1437653palpations
peltations12311553peltations
percolations1648053percolations
perforations1747873perforations
permeations1549883permeations
peroration12316003peroration_
personations1448393personations
phonathons1843453phonathons
phonation1439393phonation_
pinnations1236883pinnations
placations1438583placations
planations1238723planations
plications14310493plications
portions10514413p_o_rtions
positions11811503p_ositions
potation101716783p_otation_
potions93417423p_o__tions
precautions1546553precautions
predation12313463predation_
prelibations16127623prelibations
prenotions1248293prenotions
preobtains1443823preobtai_ns
preoptions1447643preoptions
privation14311173privation_
proaction13410103proaction_
probates12414283probat__es
probationary1953223probationary
probative1649173probati_ve
probatory1647113probat_ory
probities13312653probiti_es
procreations1647273procreations
procurations1647403procurations
productions1647533productions
profanations17175253profanations
profusions1545253profusions
prohibitions1953833prohibitions
projections2258473projections
prolactins1447153prolacti_ns
prolamins13159703prolami_ns
prolusions1245883prolusions
promotion1359503promotion_
pronating12313763pronati_ng
pronators11411303pronat_ors
propagations1745553propagations
propitious1446603propitious
proportions1548463proportions
prorating12314283prorati_ng
prorogations1556723prorogations
prostrations1449773prostrations
protamins131410773protami_ns
protections15510703protections
protonations1449073protonations
protons93118003pro__t_ons
protractions1646643protractions
provisions1547213provisions
provocations1956873provocations
pulsations1236373pulsations
pupations1338123p_upations
purgations1346743purgations
quotations19146283quotations
rations74123433_r__ations
relations92418333_relations
reprobation1548503reprobation_
rogation91612053_rogation_
rotation81615453_rotation_
solations9814623_solations
trabeations1345373trabeations
urinations10310693urinations
violations1337963violations
vocations141911423_vocations
zonations18139313_zonations

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 Filter1786911406030.406440125.6
2DLD Change Limit1406031247.29619271.2
3Display Results1241240.0631968.3
 (SQL Overall)1786911247.76523012.4
 
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.