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

244 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
unpitted114862(None) 
unbitted1138211unbitted
unfitted1238161unfitted
unpitied1138791unpitied
unpotted11108391unpotted
unwitted1237541unwitted
inputted1134662inputted
knitted12337422kn_itted
pitted94319592__pitted
spitted103912702_spitted
unbitten1045212unbitten
unbitter1046172unbitter
undotted1048522undotted
ungifted13116832ungifted
unhatted1238182unhatted
united74421542un_i_ted
unknitted1443702unknitted
unletted9310312unletted
unlisted9311152unlisted
unmatted1138292unmatted
unmitred1136842unmitred
unpainted1237182unpainted
unparted11310822unparted
unpicked17237212unpicked
unpiled102312742unpi_led
unpinned1136382unpinned
unpointed1237152unpointed
unposted1159432unposted
unprinted1238132unprinted
unsifted12128772unsifted
unspotted1244932unspotted
untilted9610892untilted
untitled978762untitled
unwetted1238122unwetted
admitted1234763admitted
anointed938343anointed
befitted14305723befitted
bitted94418483__bitted
capitated14159043capitated
demitted12288773demitted
depicted1437743depicted
emitted103010853_emitted
endited93512913endi_ted
enlisted978193enlisted
entitled967503entitled
expiated18168523expiated
fitted104716663__fitted
flitted114011643_flitted
fritted113611333_fritted
gitted84015053__gitted
gritted94110903_gritted
incited103314623inci_ted
indicted1249203indicted
indited93515023indi_ted
inputter1034203inputter
insetted9249023insetted
insisted998673insisted
intitled967343intitled
invited113612463invi_ted
kitted115114833__kitted
knitter11348133kn_itter
knotted12357233kn_otted
netted74118713_n_etted
nutted74316973_n_utted
omitted10347893_omitted
opiated1039483_opiated
outfitted1345193outfitted
outpitied1245903outpitied
outputted1244653outputted
outwitted1345133outwitted
patted94724683__patted
petted94121523__petted
pipetted1335263pipetted
pithed124615613__pithed
pitied94017253__pitied
potted94624013__potted
putted94220253__putted
quitted17339893_quitted
refitted12309413refitted
remitted113312073remitted
repotted1139283repotted
shitted114212053_shitted
slitted83513313_slitted
sopited104211063sopi_ted
spatted104014143_spatted
spirted103913073_spirted
spited94820443_spi_ted
spitter94015183_spitter
spotted103713143_spotted
submitted1445233submitted
twitted11326633_twitted
umpired1235783umpi_red
unabated11310133unabated
unabetted1244993unabetted
unacted10312733un_acted
unadmitted1443023unadmitted
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unbasted112510073unbasted
unbated103317733un_bated
unbathed1437223unbathed
unbelted1179333unbelted
unbiased1147153unbiased
unbigoted1343993unbigoted
unbilled1188693unbilled
unbolted1179323unbolted
unbooted1188773unbooted
unbottled1244153unbottled
unbusted11258773unbusted
uncarted11312053uncarted
uncoated11314963uncoated
uncrated11416313uncrated
undated93118463un_dated
undented102313953undented
undiluted1144903undiluted
undimmed1434113undimmed
unedited10249833unedited
unfelted1279403unfelted
unfetter1136753unfetter
unfilled1298383unfilled
unfilmed1495803unfilmed
unfired112212453unfi_red
unfished15218293unfished
unfixed18218563unfi_xed
unfluted1237173unfluted
ungated92717213un_gated
ungirded1136083ungirded
ungotten944533ungotten
unheated121514553unheated
unhinged13257473unhinged
unhired112512153unhi_red
unhitched1843093unhitched
unified112413573un_ified
unitard838003un_itard
unite54828383un_i_te_
uniter64619143un_i_ter
unites65024853un_i_tes
unities72520153un_ities
unitized1839233un_itized
unjointed1755583unjointed
unkinked12215903unkinked
unkissed1334893unkissed
unknotted1443623unknotted
unlicked15248263unlicked
unlighted1455783unlighted
unliked122411283unli_ked
unlimited1245923unlimited
unlined82515803unli_ned
unlinked13237793unlinked
unlived112511373unli_ved
unmated103317023un_mated
unmelted1169183unmelted
unmilled1197853unmilled
unmined102612953unmi_ned
unmiter9310393unmi_ter
unmitered1245853unmitered
unmitre936993unmitre_
unmitres1036863unmitres
unmixed17228213unmi_xed
unnoted8311363un_noted
unoiled82415483unoi_led
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unp_aged
unpaired11208943unpaired
unpatched1744053unpatched
unpaved133410053unp_aved
unpeeled11118533unpeeled
unpegged1334353unpegged
unpenned1137543unpenned
unpierced1443443unpierced
unpile81914323unpi_le_
unpiles92112783unpi_les
unplaced1338613unplaced
unplaited1236883unplaited
unplanted1236853unplanted
unplayed1437263unplayed
unplowed1436353unplowed
unpoised1139183unpoised
unpolled1168943unpolled
unposed10711903unp_osed
unpriced1338143unpriced
unprimed1337203unprimed
unprized2038513unprized
unprobed1366973unprobed
unproved1457533unproved
unpruned1136863unpruned
unpurged1236293unpurged
unquoted1836533unquoted
unrated82621553un_rated
unrented92413923unrented
unrested91914513unrested
unribbed1334173unribbed
unrifled1237423unrifled
unrigged1165643unrigged
unrimed102211633unri_med
unrinsed938383unrinsed
unripped1335763unripped
unrooted9810513unrooted
unrusted92310353unrusted
unsalted9510923unsalted
unsated83419933un_sated
unseated91317683unseated
unsettled1055213unsettled
unshifted16124943unshifted
unshirted13105953unshirted
unsighted1455433unsighted
unsigned1037563unsigned
unsized172510543unsi_zed
unsorted9312513unsorted
unspilled1245093unspilled
unstated91615813unstated
unstinted1038563unstinted
unsuited9310793unsuited
untainted1038423untainted
untasted92011573untasted
untented92613413untented
untested92612413untested
untidied1038903untidied
untied73720813un__tied
untilled9710563untilled
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
untufted1236083untufted
untwisted1344863untwisted
ununited938683ununited
unvested122210223unvested
unvisited1345173unvisited
unwanted12249603unwanted
unwasted12259783unwasted
unwilled1277823unwilled
unwished15237833unwished
unwonted12248643unwonted
unwritten1243143unwritten
unzipped2233213unzipped
updated11369423u_pdated
uplifted1454423uplifted
uppiled12216593uppi_led
uprated103213323u_prated
uptilted1174683uptilted
witted104216813__witted

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.403443402.0
2DLD Change Limit1461622446.26623326.2
3Display Results2442440.1102218.2
 (SQL Overall)1786912446.77926359.5
 
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.