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

274 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
unposted115943(None) 
unposed10711901unpos_ed
unpotted11108391unpotted
imposted13257402imposted
posted93722492__posted
riposted11216932riposted
unbasted112510072unbasted
unbolted1179322unbolted
unbooted1188772unbooted
unbusted11258772unbusted
uncoated11314962uncoated
undotted1048522undotted
unlisted9311152unlisted
unnoted8311362unno_ted
unparted11310822unparted
unpitted1148622unpitted
unpointed1237152unpointed
unpoised1139182unpoised
unpolled1168942unpolled
unrested91914512unrested
unroasted1036612unroasted
unrooted9810512unrooted
unrusted92310352unrusted
unsorted9312512unsorted
unspotted1244932unspotted
untasted92011572untasted
untested92612412untested
unvested122210222unvested
unwasted12259782unwasted
unwonted12248642unwonted
accosted1345513accosted
apposed1247853appos_ed
boosted104111983_boosted
cohosted1436133cohosted
composted16378813composted
costed95623113__costed
deported1249703deported
deposed113412023depos_ed
deposited1346773deposited
encysted1444293encysted
endostea944953endostea
enlisted978193enlisted
enrooted977423enrooted
exported1837133exported
exposed1737443expos_ed
exposited1945303exposited
frosted113211873_frosted
ghosted1236273_ghosted
hosted105020343__hosted
impasted13297553impasted
imported13308693imported
imposed123110293impos_ed
imposter12288163imposter
infested12249643infested
ingested10259003ingested
ingoted939183ingo_ted
inpoured1135813inpoured
inputted1134663inputted
insisted998673insisted
intorted9310123intorted
invested12229693invested
knotted12357233kn_otted
knouted12416773kn_outed
nested74720063_n_ested
noosed75018013_noos_ed
nosed65524553_n_os_ed
noshed104413503_n_oshed
noted65123843_n_o_ted
opposed1236123oppos_ed
pasted94426903__pasted
ported94223243__ported
posed85828413__pos_ed
posited10511493__posited
poster84129173__poster
potted94624013__potted
pouted94021393__pouted
purported1443463purported
purposed1335263purpos_ed
repasted112611533repasted
reported11312703reported
reposed103616273repos_ed
reposited1239133reposited
repotted1139283repotted
riposte9269623riposte_
ripostes10239083ripostes
roosted83211883_roosted
signposted1451453signposted
snooted84213283sn_ooted
snorted83813493sn_orted
snouted84311343sn_outed
sported104015433_sported
spotted103713143_spotted
spouted103412263_spouted
supported1444683supported
supposed1345783suppos_ed
unabated11310133unabated
unaborted1245733unaborted
unacted10312733un_acted
unadopted1344563unadopted
unasked122010023un_asked
unbased103513483unbas_ed
unbated103317733un_bated
unbelted1179333unbelted
unbitted1138213unbitted
unbobbed1234413unbobbed
unbodied1237263unbodied
unboiled112410373unboiled
unbonded12299763unbonded
unboned103014223unbo_ned
unbosomed1464253unbosomed
unbottled1244153unbottled
unbowed132610243unbo_wed
unboxed17249573unbo_xed
uncarted11312053uncarted
uncased104216953uncas_ed
uncashed14299763uncashed
uncasked15278453uncasked
unclosed111010503unclos_ed
uncocked17248753uncocked
uncoded11312743unco_ded
uncoiled112512683uncoiled
uncoined111813023uncoined
uncombed1536323uncombed
uncooked15269113uncooked
uncooled112710633uncooled
uncorked152210403uncorked
uncorseted1345153uncorseted
uncounted1238523uncounted
uncrated11416313uncrated
uncrossed1236313uncrossed
undated93118463un_dated
undented102313953undented
undocked16277633undocked
undoubted1344463undoubted
unedited10249833unedited
unexposed1943433unexpos_ed
unfasten1144843unfasten
unfelted1279403unfelted
unfished15218293unfished
unfitted1238163unfitted
unfluted1237173unfluted
unfoiled12249723unfoiled
unfolded1338313unfolded
unforced14239133unforced
unforested1444803unforested
unforged13238623unforged
unforked16218953unforked
unformed14239573unformed
unfused11319513unfus_ed
ungated92717213un_gated
ungifted13116833ungifted
unglossed1144133unglossed
ungotten944533ungotten
ungowned1335183ungowned
unhatted1238183unhatted
unheated121514553unheated
unhooded13277873unhooded
unhooked16286743unhooked
unhoped13249353unho_ped
unhorsed1238833unhorsed
unhoused1238153unhoused
unhusked1634603unhusked
unissued934683unissued
united74421543un__ited
unjoined16248443unjoined
unjointed1755583unjointed
unkissed1334893unkissed
unknotted1443623unknotted
unkosher1573763unkosher
unlashed12289183unlashed
unletted9310313unletted
unloaded1049533unloaded
unlobed10219743unlo_bed
unlocated1238383unlocated
unlocked15268383unlocked
unloosed9117523unloosed
unloved112310533unlo_ved
unmasked15267143unmasked
unmated103317023un_mated
unmatted1138293unmatted
unmelted1169183unmelted
unmeshed1437003unmeshed
unmolded1237453unmolded
unmolested1343783unmolested
unmolten1044933unmolten
unmoored1137333unmoored
unmounted1245903unmounted
unmoved13248903unmo_ved
unoiled82415483un_oiled
unopened1137023unopened
unopposed1443133unoppos_ed
unowned1148813un_owned
unpacked17268663unpacked
unpadded1345183unpadded
unpaged113311043unp_aged
unpainted1237183unpainted
unpaired11208943unpaired
unpaved133410053unp_aved
unpeeled11118533unpeeled
unpegged1334353unpegged
unpenned1137543unpenned
unpeopled1444533unpeopled
unpicked17237213unpicked
unpiled102312743unp_iled
unpinned1136383unpinned
unpitied1138793unpitied
unplaced1338613unplaced
unplaited1236883unplaited
unplanted1236853unplanted
unplayed1437263unplayed
unplowed1436353unplowed
unpoetic1245313unpoetic
unpoliced1445163unpoliced
unpolished1643433unpolished
unpolite1049173unpolite_
unpolluted1342133unpolluted
unpressed1237953unpressed
unpriced1338143unpriced
unprimed1337203unprimed
unprinted1238133unprinted
unprized2038513unprized
unprobed1366973unprobed
unprompted1743113unprompted
unproved1457533unproved
unpruned1136863unpruned
unpurged1236293unpurged
unquoted1836533unquoted
unrated82621553un_rated
unrented92413923unrented
unreported1344073unreported
unrobed102711213unro_bed
unrolled9610413unrolled
unroofed12106773unroofed
unroped102812103unro_ped
unrushed12247573unrushed
unsalted9510923unsalted
unsated83419933un_sated
unseated91317683unseated
unshed10313773un__shed
unsifted12128773unsifted
unsoaked1338853unsoaked
unsoiled92412083unsoiled
unsolved1237833unsolved
unsoothed1344253unsoothed
unsoured9310063unsoured
unsowed112511053unso_wed
unspoiled12255563unspoiled
unspooled12254913unspooled
unstated91615813unstated
unstep839223un__step
unsuited9310793unsuited
untented92613413untented
untilted9610893untilted
untufted1236083untufted
untwisted1344863untwisted
ununited938683ununited
unused72012883un_us_ed
unvisited1345173unvisited
unvoiced14106303unvoiced
unwanted12249603unwanted
unwashed15288483unwashed
unwetted1238123unwetted
unwished15237833unwished
unwitted1237543unwitted
unwooded13207443unwooded
unwooed11229773unwo_oed
unworked16238503unworked
unyoked1567123unyo_ked
unzoned172310653unzo_ned
updated11369423u_pdated
uprated103213323u_prated
uprooted1186393uprooted
upstep1035503u_p_step
uptossed1142933uptossed

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.406440125.6
2DLD Change Limit1461622746.47022590.7
3Display Results2742740.1102490.9
 (SQL Overall)1786912746.98625578.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.