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

179 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
unmitred113684(None) 
unmitered1245851unmitered
unmitre936991unmitre_
unmitres1036861unmitres
mitred94414342__mitred
unaired82916012unai_red
unbitted1138212unbitted
unfired112212452unfi_red
unfitted1238162unfitted
unhired112512152unhi_red
united74421542un_it_ed
unmarred11258402unmarred
unmated103317022unmat_ed
unmatted1138292unmatted
unmatured1245692unmatured
unmilled1197852unmilled
unmined102612952unmi_ned
unmiter9310392unmit_er
unmiters1037072unmiters
unmixed17228212unmi_xed
unmoored1137332unmoored
unpitied1138792unpitied
unpitted1148622unpitted
untired82316382unti_red
untitled978762untitled
unwitted1237542unwitted
admired1135703admi_red
admitted1234763admitted
antired82316193anti_red
bemired123410633bemi_red
demitted12288773demitted
emitted103010853_emitted
endited93512913endit_ed
enmities10611353enmities
entitled967503entitled
incited103314623incit_ed
indited93515023indit_ed
intitled967343intitled
invited113612463invit_ed
knitted12337423kn_itted
limited102310233limit_ed
metred95315143__metred
mired85729223__mi_red
mitered103213233__mitered
mitre75522423__mitre_
mitres83922073__mitres
nitre57519683_n_itre_
nitres65519333_n_itres
nitrid72812233_n_itrid
numbered13147143numbered
omitted10347893_omitted
remitted113312073remitted
submitted1445233submitted
summited13246413summit_ed
umbered121510113u_mbered
umpired1235783u_mpired
unacted10312733unact_ed
unadmired1343863unadmi_red
unadmitted1443023unadmitted
unaided92414603unai_ded
unaimed102812493unai_med
unaltered1037723unaltered
unattired1045083unattired
unbarred11238703unbarred
unbated103317733unbat_ed
unbathed1437223unbathed
unbeared111611653unbeared
unbiased1147153unbiased
unbilled1188693unbilled
unbitten1045213unbitten
unbitter1046173unbitter
unbred92613303un__bred
uncarted11312053uncarted
uncatered1237403uncatered
uncured10513233un_cured
undated93118463undat_ed
undimmed1434113undimmed
undotted1048523undotted
unedited10249833unedit_ed
unentered1037573unentered
unfeared121511013unfeared
unfilled1298383unfilled
unfilmed1495803unfilmed
unfiltered1443563unfiltered
unfished15218293unfished
unfixed18218563unfi_xed
ungated92717213ungat_ed
ungifted13116833ungifted
ungird887973ungi_r_d
ungirded1136083ungirded
unhaired12238763unhaired
unhatted1238183unhatted
unhinged13257473unhinged
unhitched1843093unhitched
unified112413573un_ified
unimbued1343073unimbued
unitard838003un_itard
unite54828383un_it_e_
uniter64619143un_it_er
uniters73814173un_iters
unites65024853un_it_es
unities72520153un_ities
unitized1839233un_itized
unkinked12215903unkinked
unkissed1334893unkissed
unknitted1443703unknitted
unletted9310313unletted
unlicked15248263unlicked
unliked122411283unli_ked
unlimited1245923unlimit_ed
unlined82515803unli_ned
unlinked13237793unlinked
unlisted9311153unlisted
unlived112511373unli_ved
unmailed11229763unmailed
unmanned11268603unmanned
unmapped1535173unmapped
unmarked15248813unmarked
unmarried1244583unmarried
unmasked15267143unmasked
unmatched1744203unmatched
unmelted1169183unmelted
unmended12299093unmended
unmerited1239643unmerit_ed
unmeshed1437003unmeshed
unmewed13258173unm_ewed
unmingled1344283unmingled
unmitring1245263unmitring
unmixes16197753unmi_xes
unmolded1237453unmolded
unmonitored1451673unmonitored
unmourned1254153unmourned
unmoved13248903unm_oved
unnoted8311363unnot_ed
unoiled82415483unoi_led
unpaired11208943unpaired
unparted11310823unparted
unpicked17237213unpicked
unpierced1443443unpierced
unpiled102312743unpi_led
unpinned1136383unpinned
unpotted11108393unpotted
unrated82621553unrat_ed
unretired1046433unretired
unribbed1334173unribbed
unrifled1237423unrifled
unrigged1165643unrigged
unrimed102211633unri_med
unrinsed938383unrinsed
unripped1335763unripped
unsated83419933unsat_ed
unseared91113943unseared
unshared121510703unshared
unshirted13105953unshirted
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543unsi_zed
unsorted9312513unsorted
unsoured9310063unsoured
unsuited9310793unsuit_ed
untidied1038903untidied
untied73720813un__tied
untilled9710563untilled
untilted9610893untilted
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untread857413un__tread
untried82615853un__tried
untrod769853un__trod
untutored1043493untutored
ununited938683ununit_ed
unuttered1065733unuttered
unwatered1345683unwatered
unwetted1238123unwetted
unwilled1277823unwilled
unwished15237833unwished
unzipped2233213unzipped
vomited1337253vomit_ed

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 Limit1461621797.23620199.3
3Display Results1791790.0762355.3
 (SQL Overall)1786911797.76523012.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.