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

200 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
unpinned113638(None) 
unpenned1137541unpenned
pinned94818382__pinned
repinned1157472repinned
unbanned11279112unbanned
uncanned11289962uncanned
unhinged13257462unhinged
unkenned1336182unkenned
unkinked12215902unkinked
unlined82515802unli_ned
unlinked13237792unlinked
unmanned11268602unmanned
unmined102612952unmi_ned
unpainted1237182unpainted
unpicked17237212unpicked
unpiled102312742unpi_led
unpitied1138772unpitied
unpitted1148622unpitted
unplanned1244412unplanned
unpointed1237152unpointed
unprinted1238132unprinted
unpruned1136862unpruned
unrinsed938372unrinsed
unsigned1037552unsigned
untanned9279962untanned
untinged10308932untinged
anointed938343anointed
binned94414543__binned
chinned134810493_chinned
dinned84317613__dinned
engined9119893engi_ned
enplaned1137473enplaned
finned104114603__finned
ginned83813983__ginned
grinned9378553_grinned
impinged14275123impinged
inned64118423___inned
inspanned1242853inspanned
japanned1843143japanned
opined95113853_opi_ned
outsinned1045673outsinned
panned94123433__panned
penned94217613__penned
pined85935323__pi_ned
pinged104321383__pinged
pinked134819883__pinked
pinner84521493__pinner
punned93416193__punned
repined104918773repi_ned
shinned114310913_shinned
sinned73818413__sinned
skinned12387293_skinned
spanned104111223_spanned
spined95423943_spi_ned
spinner93912263_spinner
spinney12438923_spinney
suntanned1044013suntanned
thinned11399153_thinned
tinned74317533__tinned
twinned11366333_twinned
umpired1235783umpi_red
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unaligned1144873unaligned
unatoned939423unatoned
unbanded123010563unbanded
unbended12279973unbended
unbiased1147143unbiased
unbilled1188693unbilled
unbind93011423unbi_n_d
unbitted1138213unbitted
unblinded13295233unblinded
unbonded12299763unbonded
unboned103014223un_boned
unbonnet1047173unbonnet
unburned11227413unburned
uncoined111813023uncoined
undenied102211553undenied
undented102313953undented
underpinned1544053underpinned
undimmed1434103undimmed
undine7817263undi_ne_
undines8716083undi_nes
unearned9310063unearned
unended92811823un_ended
unfeigned1453293unfeigned
unfenced1437733unfenced
unfilled1298383unfilled
unfilmed1495803unfilmed
unfired112212453unfi_red
unfished15218283unfished
unfitted1238163unfitted
unfixed18218563unfi_xed
unfunded1336473unfunded
ungifted13116833ungifted
ungirded1136083ungirded
ungowned1335183ungowned
unhanded132910183unhanded
unhanged13258833unhanged
unhinge11237283unhinge_
unhinges12266723unhinges
unhired112512153unhi_red
unified112413563un_ified
unironed939083unironed
united74421543un_i_ted
unjoined16248443unjoined
unjointed1755583unjointed
unkennel1243833unkennel
unkind113310573unki_n_d
unkinder1335363unkinder
unkindled1594203unkindled
unkissed1334883unkissed
unlicked15248263unlicked
unliked122411283unli_ked
unlisted9311143unlisted
unlived112511373unli_ved
unmended12299093unmended
unmilled1197853unmilled
unmingled1344273unmingled
unmitred1136843unmitred
unmixed17228213unmi_xed
unoiled82415473unoi_led
unopened1137023unopened
unowned1148803un_owned
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unp_aged
unpaired11208943unpaired
unparted11310823unparted
unpaved133410053unp_aved
unpeeled11118533unpeeled
unpegged1334353unpegged
unpierced1443443unpierced
unpile81914323unpi_le_
unpiles92112783unpi_les
unpin72613243unpi_n__
unpinning1245623unpinning
unpins82312383unpi_n_s
unplaced1338613unplaced
unplanted1236853unplanted
unplayed1437263unplayed
unplowed1436353unplowed
unpoised1139173unpoised
unpolled1168943unpolled
unposed10711903unp_osed
unposted1159433unposted
unpotted11108393unpotted
unpriced1338143unpriced
unprimed1337193unprimed
unprized2038503unprized
unprobed1366973unprobed
unproved1457533unproved
unpurged1236293unpurged
unranked1338563unranked
unrented92413923unrented
unribbed1334173unribbed
unrifled1237423unrifled
unrigged1165633unrigged
unrimed102211633unri_med
unripened1244393unripened
unripped1335763unripped
unscanned1245133unscanned
unsifted12128773unsifted
unsized172510533unsi_zed
unspilled1245093unspilled
unstinted1038553unstinted
unstoned9311043unstoned
untainted1038423untainted
untended102611153untended
untented92613413untented
untidied1038883untidied
untied73720813unti__ed
untilled9710563untilled
untilted9610893untilted
untimed102713363unti_med
untipped1335763untipped
untired82316383unti_red
untitled978763untitled
untuned82010823un_tuned
unturned9228563unturned
untwined1237063untwined
ununited938683ununited
unveined1258003unveined
unwanted12249603unwanted
unwarned1238453unwarned
unweaned1238593unweaned
unwilled1277823unwilled
unwind102610543unwi_n_d
unwinder1235613unwinder
unwished15237823unwished
unwitted1237543unwitted
unwonted12248643unwonted
unyeaned1237743unyeaned
unzipped2233213unzipped
unzoned172310653un_zoned
upended11267323u_pended
uplinked15254203uplinked
uppiled12216593uppi_led
winned104017013__winned

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622007.37619815.9
3Display Results2002000.0762631.6
 (SQL Overall)1786912007.60823487.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.