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

235 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
unsifted1212877(None) 
ungifted13116831ungifted
unshifted16124941unshifted
insisted998672insisted
resifted12310152resifted
sifted104313672__sifted
unbitted1138212unbitted
unfitted1238162unfitted
unified112413572un_ified
united74421542un_i_ted
unlisted9311152unlisted
unpitted1148622unpitted
unrifled1237422unrifled
unsalted9510922unsalted
unsated83419932uns_ated
unseated91317682unseated
unshirted13105952unshirted
unsighted1455432unsighted
unsigned1037562unsigned
unsized172510542unsi_zed
unsorted9312512unsorted
unstated91615812unstated
unstinted1038562unstinted
unsuited9310792unsuited
untilted9610892untilted
untufted1236082untufted
unwitted1237542unwitted
uplifted1454422uplifted
upshifted1882202upshifted
anointed938343anointed
ansated84214003ans_ated
assisted936233assisted
basified1437823basified
consisted1238503consisted
densified1446713densified
desisted1039783desisted
drifted12367953_drifted
endited93512913endi_ted
enlisted978193enlisted
ensiled82611433ensi_led
gasified1336533gasified
gifted114510703__gifted
grifted12379583_grifted
incited103314623inci_ted
indicted1249203indicted
indited93515023indi_ted
inserted92413053inserted
insetted9249023insetted
insister888783insister
instated91613343instated
insulted937193insulted
invited113612463invi_ted
knifed14528123kn_if_ed
knitted12337423kn_itted
lifted104413523__lifted
ossified1276433ossified
posited10511493posi_ted
presifted1536873presifted
resisted9312693resisted
resited85122423resi_ted
rifted104115313__rifted
russified1344733russified
shifted14359983_shifted
sifter94516233__sifter
silted74020013__silted
sited65130743__si_ted
sniffed14318183sn_iffed
snifter10349623sn_ifter
subsisted1245783subsisted
uglified1345293uglified
unabated11310133unabated
unacted10312733un_acted
unaided92414603unai_ded
unaimed102812493unai_med
unaired82916013unai_red
unassisted1143833unassisted
unbasted112510073unbasted
unbated103317733un_bated
unbelted1179333unbelted
unbiased1147153unbiased
unbigoted1343993unbigoted
unbilled1188693unbilled
unbitten1045213unbitten
unbitter1046173unbitter
unbolted1179323unbolted
unbooted1188773unbooted
unbusted11258773unbusted
uncarted11312053uncarted
uncoated11314963uncoated
uncrated11416313uncrated
uncuffed1734083uncuffed
undated93118463un_dated
undented102313953undented
undiluted1144903undiluted
undimmed1434113undimmed
undotted1048523undotted
unedited10249833unedited
unfed94614223un__f_ed
unfelted1279403unfelted
unfilled1298383unfilled
unfilmed1495803unfilmed
unfired112212453unfi_red
unfished15218293unfished
unfixed18218563unfi_xed
unfluted1237173unfluted
ungated92717213un_gated
ungirded1136083ungirded
unhatted1238183unhatted
unheated121514553unheated
unhinged13257473unhinged
unhired112512153unhi_red
unifier102211863un_ifier
unifies102714713un_ifies
unissued934683unissued
unite54828383un_i_te_
uniter64619143un_i_ter
unites65024853un_i_tes
unjointed1755583unjointed
unkinked12215903unkinked
unkissed1334893unkissed
unknitted1443703unknitted
unletted9310313unletted
unlicked15248263unlicked
unlighted1455783unlighted
unliked122411283unli_ked
unlimited1245923unlimited
unlined82515803unli_ned
unlinked13237793unlinked
unlived112511373unli_ved
unmated103317023un_mated
unmatted1138293unmatted
unmelted1169183unmelted
unmilled1197853unmilled
unmined102612953unmi_ned
unmiter9310393unmi_ter
unmitred1136843unmitred
unmixed17228213unmi_xed
unnoted8311363un_noted
unoiled82415483unoi_led
unpainted1237183unpainted
unparted11310823unparted
unpicked17237213unpicked
unpiled102312743unpi_led
unpinned1136383unpinned
unpitied1138793unpitied
unpointed1237153unpointed
unposted1159433unposted
unpotted11108393unpotted
unprinted1238133unprinted
unquoted1836533unquoted
unrated82621553un_rated
unrented92413923unrented
unrested91914513unrested
unribbed1334173unribbed
unrigged1165643unrigged
unrimed102211633unri_med
unrinsed938383unrinsed
unripped1335763unripped
unrooted9810513unrooted
unrusted92310353unrusted
unsafe9310693unsaf_e_
unsafety1443043unsafety
unsaved113312193uns_aved
unsawed112911503uns_awed
unscaled111410113unscaled
unscathed1535313unscathed
unscented1237513unscented
unscripted1544633unscripted
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseeded1038253unseeded
unseized1838443unseized
unserved12410233unserved
unsettled1055213unsettled
unsewed112911023uns_ewed
unsexed152410253uns_exed
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshared121510703unshared
unshaved15157733unshaved
unshed10313773uns__hed
unshift1387423unshift__
unshifts1444033unshift_s
unshipped1743863unshipped
unsicker1435303unsicker
unskilled1444603unskilled
unslaked1338463unslaked
unsliced1138093unsliced
unsmoked1536013unsmoked
unsoaked1338853unsoaked
unsoiled92412083unsoiled
unsolved1237833unsolved
unsoothed1344253unsoothed
unsoured9310063unsoured
unsowed112511053uns_owed
unspilled1245093unspilled
unspotted1244933unspotted
unstate71916213unstate_
unstates81314993unstates
unstayed12168393unstayed
unstep839223uns__tep
unstoned9311043unstoned
unstuffed1642683unstuffed
unswathed1634543unswathed
unswayed15155713unswayed
untainted1038423untainted
untasted92011573untasted
untented92613413untented
untested92612413untested
untidied1038903untidied
untied73720813unti__ed
untilled9710563untilled
untimed102713373unti_med
untinged10308943untinged
untipped1335763untipped
untired82316383unti_red
untitled978763untitled
untwisted1344863untwisted
ununited938683ununited
unvested122210223unvested
unvisited1345173unvisited
unwanted12249603unwanted
unwasted12259783unwasted
unwetted1238123unwetted
unwilled1277823unwilled
unwished15237833unwished
unwonted12248643unwonted
unzipped2233213unzipped
uplifter1363903uplifter
upsized19246253upsi_zed
uptilted1174683uptilted
upwafted1742193upwafted
visited1168773visi_ted

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.423422437.4
2DLD Change Limit1461622356.32623105.0
3Display Results2352350.0962447.9
 (SQL Overall)1786912356.84526105.3
 
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.