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

70 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
unpitying154404(None) 
outpitying1644772outpitying
pitying132910242__pitying
unfitting1336422unfitting
unifying1537552un_ifying
uniting8315822un_it_ing
unmitring1245262unmitring
unpaying1456942unp_aying
unpicking1834882unpicking
unpiling1139752unpi_ling
unpinning1245622unpinning
untidying1445472untidying
untying1138942un__tying
unwitting1335582unwitting
emptying1634243emp_tying
enditing10311073endit_ing
entitling1037103entitling
inciting11312533incit_ing
inditing10312113indit_ing
inputting1235823inputting
intitling1037213intitling
inviting1239733invit_ing
knitting13257023kn_itting
pithing134014053__pithing
pitting103618873__pitting
sopiting11310763sopit_ing
spiting103917623_spit_ing
spitting113012323_spitting
typifying2143323typifying
uglifying1743963uglifying
umpiring1336093umpi_ring
unbinding1336513unbinding
uncloying1555813uncloying
undying1238503un__dying
unedifying1843723unedifying
unfixing1935683unfi_xing
ungirding1245153ungirding
ungiving1346333ungi_ving
unhatting1335873unhatting
unhinging1436093unhinging
unhitching1942843unhitching
unitizing1947803un_itizing
unkinking1334783unkinking
unknitting1542873unknitting
unlaying1258363un_laying
unlinking1436273unlinking
unliving1248193unli_ving
unmitering1345003unmitering
unmixing1835543unmi_xing
unpacking1835133unpacking
unpegging1443863unpegging
unpenning1236183unpenning
unpitied1138793unpit_ied
unplaiting1345503unplait_ing
unrigging1245183unrigging
unripping1434643unripping
unsaying1288153un_saying
unsetting1088993unsetting
unstring9312093un_string
untieing938863unti_eing
untiring9312003unti_ring
unvarying1644503unvarying
unwilling1337163unwilling
unwinding1435843unwinding
unwinking1735073unwinking
unwishing1635593unwishing
unzipping2342703unzipping
updrying1534013u_pdrying
uppiling1335853uppi_ling
yuppifying2442443yuppifying

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.1561145455.1
2DLD Change Limit148641707.28020417.7
3Display Results70700.0332121.2
 (SQL Overall)178691707.46923924.4
 
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.