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

119 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
punition103837(None) 
munition1038761munition
punitions1137921punitions
audition979172audition
function1337842function
ignition946532ignition
junction1736202junction
lenition8310082lenition
lunation8311922lunation
monition10311722monition
munitions1138172munitions
petition10711752petition
position10912192position
punitive1346832punitive
pupation1269502pupation
tuition738822tu_ition
unction9310662_unction
addition1096893addition
adnation9310783adnation
agnation9311723agnation
ambition1246563ambition
ammunition14103813ammunition
auction93412933au_ction
auditions1078753auditions
bunion83111313bun__ion
cognition1247013cognition
coition9314313_coition
conation101420883conation
condition12411163condition
dentition1049633dentition
donation91513783donation
dunitic1048143duniti_c
duration9312693duration
edition8310853_edition
enation73419233_enation
erudition1046173erudition
expunction2143573expunction
fruition11106103fruition
functions1437743functions
gumption1343983gumption
ignitions1045803ignitions
ignitron943203ignitron
inanition947293inanition
inunction1146893inunction
junctions1835943junctions
lenitions939473lenitions
lunations9310723lunations
luxation1538233luxation
mention9314373men_tion
monitions11310883monitions
munitioned1353943munitioned
munnion935863mun_nion
muntin82915183mun_ti_n
mutation101412883mutation
nation64322803__nation
niton55418283__nit_on
notion64516583__notion
nunnation9126563nunnation
nutation81513103nutation
nutrition966733nutrition
paction112713963p_action
partition1148693partition
pavilion1344913pavilion
pension9412203pen_sion
perdition1249013perdition
petitions11511083petitions
phonation1439393phonation
pinion83815893p__inion
pinitol936683pinit_ol
pinnation1138013pinnation
piton76121583p__it_on
planation11310123planation
ponton83217643pon_t_on
pontoon93010703pon_toon
portion9615493p_ortion
positions11811503positions
positron1096903positron
potation101716783potation
potion84519573p__otion
premunition1545573premunition
prenotion1149173prenotion
pronation11415703pronation
pulsation1137143pulsation
pulsion938393pu_lsion
puncheon1544473puncheon
punctation1486053punctation
punditic1364983punditi_c
punitory1345603punitory
punkin123611523pun_ki_n
punties94520783pun_ties
punting103318443pun_ting
punto75121323pun_t_o_
puntos85915793pun_t_os
pupations1338123pupations
purgation1247393purgation
puritan939283purit_an
purities10316283purities
puton73617913pu__t_on
question1745823question
quintin163810333quinti_n
rendition1058933rendition
ruction93611613ru_ction
ruination9311273ruination
sanction1049533sanction
sedition939333sedition
suction93713043su_ction
sudation9310803sudation
tuitions838283tu_itions
unctions1039733_unctions
union54519793_un__ion
unison649033_uni_son
unities72520153_unities
uniting8315823_uniting
unitive10310563_unitive
unitize16310033_unitize
venation11513503venation
vendition1345693vendition
volition1179173volition
zonation171410723zonation

Search took 9 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 Filter1786911461620.546327272.9
2DLD Change Limit1461621197.89018525.0
3Display Results1191190.0462587.0
 (SQL Overall)1786911198.48221067.1
 
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.