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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
unpinning124562(None) 
unpenning1236181unpenning
pinning103417852__pinning
repinning12258972repinning
spinning113310812_spinning
unbanning1235892unbanning
unbinding1336512unbinding
unhinging1436092unhinging
unkinking1334782unkinking
unlinking1436272unlinking
unmanning1245872unmanning
unpicking1834882unpicking
unpiling1139752unpi_ling
unpitying1544042unpitying
unwinding1435842unwinding
unwinking1735072unwinking
anointing1038623anointing
beginning1344613beginning
binning103615453__binning
chinning14329653_chinning
dinning93416553__dinning
engining1039293engi_ning
enplaning1246803enplaning
enwinding1444933enwinding
finning113615113__finning
ginning93313983__ginning
grinning1037863_grinning
gunrunning1242123gunrunning
impinging1544203impinging
inning73617633___inning
inspanning1343203inspanning
inwinding1445173inwinding
japanning1943383japanning
nonwinning1443503nonwinning
opining10311743_opi_ning
outsinning1146173outsinning
panning104019393__panning
penning103616493__penning
pinging113419553__pinging
pining93726533__pi_ning
pinking143918943__pinking
punning103414993__punning
repining114116593repi_ning
rewinning13257443rewinning
rinning83216743__rinning
shinning123211023_shinning
sinning83918443__sinning
skinning13327893_skinning
spanning113311083_spanning
spinnings12294853_spinnings
suntanning1143983suntanning
thinning12319093_thinning
tinning83117283__tinning
twinning12367043_twinning
umpiring1336093umpi_ring
unbending1337463unbending
unblinking1743923unblinking
underpinning1653423underpinning
unending10239943un_ending
unfencing1545953unfencing
unfitting1336423unfitting
unfixing1935683unfi_xing
ungirding1245153ungirding
ungiving1346333ungi_ving
unhanding1437203unhanding
unhanging1436363unhanging
unifying1537553un_ifying
uniting8315823un_i_ting
unjointing1843963unjointing
unliving1248193unli_ving
unmeaning1237953unmeaning
unmingling1443453unmingling
unmitring1245263unmitring
unmixing1835543unmi_xing
unpacking1835133unpacking
unpaying1456943unp_aying
unpegging1443863unpegging
unpinned1136383unpinn_ed
unrigging1245183unrigging
unripping1434643unripping
unslinging1244593unslinging
unstinting1147303unstinting
unthinking1844663unthinking
untidying1445473untidying
untieing938863unti_eing
untiring9312003unti_ring
untuning937943un_tuning
untwining1346303untwining
unwaning1238133un_waning
unwilling1337163unwilling
unwishing1635593unwishing
unwitting1335583unwitting
unzipping2342703unzipping
upbinding1544303upbinding
upending12258133u_pending
uplinking1634623uplinking
uppiling1335853uppi_ling
winning113516553__winning

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 Filter1786911486410.423422437.4
2DLD Change Limit148641986.76621968.8
3Display Results98980.0462130.4
 (SQL Overall)178691987.23524698.1
 
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.