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

187 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
unpitied113879(None) 
unpitted1148621unpitted
outpitied1245902outpitied
pitied94017252__pitied
unbitted1138212unbitted
unfitted1238162unfitted
unified112413572un_ified
united74421542un_it_ed
unities72520152un_ities
unitized1839232un_itized
unmitred1136842unmitred
unpicked17237212unpicked
unpiled102312742unpi_led
unpinned1136382unpinned
unpotted11108392unpotted
untidied1038902untidied
untied73720812un__tied
untitled978762untitled
unwitted1237542unwitted
cavitied14126813cavitied
citied94014143__citied
emptied1297393emp_tied
endited93512913endit_ed
enmities10611353enmities
entities8617413entities
entitled967503entitled
incited103314623incit_ed
indited93515023indit_ed
inputted1134663inputted
intitled967343intitled
invited113612463invit_ed
knitted12337423kn_itted
nitid61817833_n_iti_d
nudities939683nudities
outpities1148623outpities
pithed124615613__pithed
pitier84019823__pitier
pities83828083__pities
pitted94319593__pitted
sopited104211063sopit_ed
spited94820443_spit_ed
spitted103912703_spitted
typified1743923typified
uglified1345293uglified
umpired1235783umpi_red
unacted10312733unact_ed
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unallied938393unallied
unapplied1443743unapplied
unattired1045083unattired
unbated103317733unbat_ed
unbathed1437223unbathed
unbiased1147153unbiased
unbilled1188693unbilled
unbitten1045213unbitten
unbitter1046173unbitter
unbodied1237263unbodied
unburied11208513unburied
undated93118463undat_ed
undenied102211563undenied
undimmed1434113undimmed
undivided1544303undivided
undotted1048523undotted
undried92314613un_dried
unedited10249833unedit_ed
unenvied1244653unenvied
unfilled1298383unfilled
unfilmed1495803unfilmed
unfired112212453unfi_red
unfished15218293unfished
unfixed18218563unfi_xed
ungated92717213ungat_ed
ungifted13116833ungifted
ungirded1136083ungirded
unhatted1238183unhatted
unhinged13257473unhinged
unhired112512153unhi_red
unhitched1843093unhitched
unifier102211863un_ifier
unifies102714713un_ifies
unitard838003un_itard
unite54828383un_it_e_
uniter64619143un_it_er
unites65024853un_it_es
uniting8315823un_iting
unitive10310563un_itive
unitize16310033un_itize
unitizer1746203un_itizer
unitizes1739133un_itizes
unkinked12215903unkinked
unkissed1334893unkissed
unknitted1443703unknitted
unletted9310313unletted
unlevied1236843unlevied
unlicked15248263unlicked
unliked122411283unli_ked
unlimited1245923unlimited
unlined82515803unli_ned
unlinked13237793unlinked
unlisted9311153unlisted
unlived112511373unli_ved
unmated103317023unmat_ed
unmatted1138293unmatted
unmilled1197853unmilled
unmined102612953unmi_ned
unmiter9310393unmit_er
unmitered1245853unmitered
unmitre936993unmitre_
unmitres1036863unmitres
unmixed17228213unmi_xed
unnoted8311363unnot_ed
unnoticed1243923unnoticed
unoiled82415483unoi_led
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unp_aged
unpaid939473unp_ai_d
unpainted1237183unpainted
unpaired11208943unpaired
unparted11310823unparted
unpatched1744053unpatched
unpaved133410053unp_aved
unpeeled11118533unpeeled
unpegged1334353unpegged
unpenned1137543unpenned
unpierced1443443unpierced
unpile81914323unpi_le_
unpiles92112783unpi_les
unpiling1139753unpiling
unpitying1544043unpitying
unplaced1338613unplaced
unplaited1236883unplaited
unplayed1437263unplayed
unplowed1436353unplowed
unpointed1237153unpointed
unpoised1139183unpoised
unpoliced1445163unpoliced
unpolled1168943unpolled
unposed10711903unp_osed
unposted1159433unposted
unpriced1338143unpriced
unprimed1337203unprimed
unprinted1238133unprinted
unprized2038513unprized
unprobed1366973unprobed
unproved1457533unproved
unpruned1136863unpruned
unpurged1236293unpurged
unrated82621553unrat_ed
unretired1046433unretired
unribbed1334173unribbed
unrifled1237423unrifled
unrigged1165643unrigged
unrimed102211633unri_med
unrinsed938383unrinsed
unripped1335763unripped
unsated83419933unsat_ed
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543unsi_zed
unspilled1245093unspilled
unspotted1244933unspotted
unsuited9310793unsuit_ed
untidier946783untidier
untidies939813untidies
untie54425493un__tie_
unties64326923un__ties
untilled9710563untilled
untilted9610893untilted
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
untried82615853un_tried
ununited938683ununit_ed
unvaried1239683unvaried
unvisited1345173unvisited
unwetted1238123unwetted
unwilled1277823unwilled
unwished15237833unwished
unzipped2233213unzipped
updried11226473u_pdried
uppiled12216593uppi_led
vanitied12138213vanitied
yuppified2042413yuppified

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.453394461.4
2DLD Change Limit1461621877.28320068.9
3Display Results1871870.0762460.5
 (SQL Overall)1786911877.81222873.9
 
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.