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

129 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
unzipped223321(None) 
unripped1335761unripped
untipped1335761untipped
nipped113615852_n_ipped
snipped123510042sn_ipped
uncapped1556692uncapped
unclipped1643842unclipped
unmapped1535172unmapped
unshipped1743862unshipped
untapped1376612untapped
unwhipped2042362unwhipped
zipped203612982__zipped
blipped14377193_blipped
chipped174110813_chipped
clipped14439833_clipped
dipped123517493__dipped
dripped13408083_dripped
equipped2243073equipped
flipped15358513_flipped
gipped124815903__gipped
gripped13419343_gripped
hipped144317693__hipped
inclipped1642583inclipped
kipped153114573__kipped
knapped16397103kn_apped
knopped16355453kn_opped
lipped114419543__lipped
napped114218163_n_apped
nipper103715713_n_ipper
nippled12307643_n_ippled
pipped104516543__pipped
quipped2175163_quipped
redipped1434783redipped
ripped114419013__ripped
shipped153312103_shipped
sipped113720633__sipped
skipped16358413_skipped
slipped124711743_slipped
snapped124611203sn_apped
sniped94913483sn_i_ped
snipper113911333sn_ipper
snippet113310433sn_ippet
stripped1357093stripped
tipped114418263__tipped
tripped123911693_tripped
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unbiased1147153unbiased
unbilled1188693unbilled
unbitted1138213unbitted
uncrippled1742553uncrippled
uncropped1644933uncropped
undamped1445333undamped
undimmed1434113undimmed
undraped1239393undraped
unfilled1298383unfilled
unfilmed1495803unfilmed
unfired112212453unfi_red
unfished15218293unfished
unfitted1238163unfitted
unfixed18218563unfi_xed
unflapped1743093unflapped
ungifted13116833ungifted
ungirded1136083ungirded
unhelped1435923unhelped
unhinged13257473unhinged
unhired112512153unhi_red
unhoped13249353un_hoped
unified112413573un_ified
unipod946853un_i_pod
united74421543un_i_ted
unkinked12215903unkinked
unkissed1334893unkissed
unlicked15248263unlicked
unliked122411283unli_ked
unlined82515803unli_ned
unlinked13237793unlinked
unlisted9311153unlisted
unlived112511373unli_ved
unmilled1197853unmilled
unmined102612953unmi_ned
unmitred1136843unmitred
unmixed17228213unmi_xed
unoiled82415483unoi_led
unpicked17237213unpicked
unpiled102312743unpi_led
unpinned1136383unpinned
unpitied1138793unpitied
unpitted1148623unpitted
unribbed1334173unribbed
unrifled1237423unrifled
unrigged1165643unrigged
unrimed102211633unri_med
unrinsed938383unrinsed
unripe82012093unri_pe_
unripened1244393unripened
unriper9188283unri_per
unroped102812103un_roped
unshaped14148443unshaped
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543unsi_zed
unsnapped1443983unsnapped
unstepped1444213unstepped
unstopped1444403unstopped
untidied1038903untidied
untied73720813unti__ed
untilled9710563untilled
untilted9610893untilted
untimed102713373unti_med
untinged10308943untinged
untired82316383unti_red
untitled978763untitled
untrapped14106123untrapped
unwarped1436873unwarped
unwilled1277823unwilled
unwished15237833unwished
unwitted1237543unwitted
unwrapped1784133unwrapped
unzip16207623unzi_p__
unzipping2342703unzipping
unzips17175273unzi_p_s
unzoned172310653unz_oned
upped103715163u___pped
whipped18379333_whipped
yipped143613283__yipped
zapped204213523__zapped
zipper193813123__zipper

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621296.17023689.1
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.63926915.3
 
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.