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

334 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
unsorted931251(None) 
assorted956592assorted
consorted1239772consorted
inserted92413052inserted
intorted9310122intorted
resorted9313492resorted
snorted83813492sn_orted
sorted74523712__sorted
unaborted1245732unaborted
unbolted1179322unbolted
unbooted1188772unbooted
uncarted11312052uncarted
uncoated11314962uncoated
uncorked152210402uncorked
undotted1048522undotted
unforced14239132unforced
unforged13238622unforged
unforked16218952unforked
unformed14239572unformed
unhorsed1238832unhorsed
unnoted8311362unno_ted
unparted11310822unparted
unposted1159432unposted
unpotted11108392unpotted
unrooted9810512unrooted
unsalted9510922unsalted
unsated83419932uns_ated
unseated91317682unseated
unserved12410232unserved
unshirted13105952unshirted
unsifted12128772unsifted
unsoaked1338852unsoaked
unsoiled92412072unsoiled
unsolved1237832unsolved
unsoothed1344252unsoothed
unsourced1244822unsourced
unsoured9310052unsoured
unsowed112511052unso_wed
unspotted1244932unspotted
unstated91615812unstated
unsuited9310782unsuited
unwonted12248642unwonted
unworked16238502unworked
aborted10310423_aborted
absorbed1344253absorbed
adsorbed1243433adsorbed
ansated84214003ans_ated
asserted957903asserted
assorter866663assorter
besotted1135843besotted
cavorted1435693cavorted
censored11197953censor_ed
contorted1239473contorted
dehorted1357303dehorted
deported1249703deported
deserted101012203deserted
desorbed1236433desorbed
disported13310303disported
distorted1139363distorted
encored10412103encor_ed
endorsed1057193endorsed
enforced14216743enforced
engorged1134553engorged
enrooted977423enrooted
enserfed1245193enserfed
ensorcel1054693ensorcel
ensouled935833ensouled
ensured83512943ensur_ed
escorted1136703escorted
exhorted1935013exhorted
exported1837133exported
exserted1636213exserted
extorted1636233extorted
imported13308693imported
indorsed1066123indorsed
informed14197673informed
ingoted939183ingo_ted
inserter82312133inserter
insetted9249023insetted
insisted998673insisted
insolated1039713insolated
insouled936113insouled
instated91613333instated
insulted937193insulted
insured83714253insur_ed
inverted122312163inverted
knotted12357223kn_otted
knouted12416763kn_outed
missorted1247033missorted
normed95014543_n_ormed
noted65123843_n_o_ted
ported94223243__ported
presorted1239453presorted
purported1443453purported
reported11312703reported
resorbed1138523resorbed
resorter8312173resorter
retorted9312333retorted
shorted113614393_shorted
snooted84213273sn_ooted
snored74819543sn_or_ed
snorter74412653sn_orter
snouted84311343sn_outed
sooted73922583__sooted
sorbed94916513__sorbed
sored66141783__sor_ed
sorned74820043__sorned
sorter64425083__sorter
sortied83314093__sortied
sotted74121393__sotted
sported104015433_sported
supported1444683supported
unabated11310133unabated
unabsorbed1542363unabsorbed
unacted10312733un_acted
unadopted1344563unadopted
unadorned1144123unadorned
unagreed1036823unagreed
unaired82916013unair_ed
unalerted1047963unalerted
unarmed101811923un_armed
unaverted1336563unaverted
unbarbed13217753unbarbed
unbarred11238703unbarred
unbasted112510073unbasted
unbated103317733un_bated
unbelted1179333unbelted
unbitted1138213unbitted
unboarded13185683unboarded
unbobbed1234413unbobbed
unbodied1237263unbodied
unboiled112410373unboiled
unbonded12299763unbonded
unboned103014223unbo_ned
unbottled1244153unbottled
unbowed132610243unbo_wed
unboxed17249573unbo_xed
unbred92613303un_br_ed
unburied11208513unburied
unburned11227413unburned
unbusted11258773unbusted
uncarded12310133uncarded
uncarved1438163uncarved
uncharted1538083uncharted
uncocked17248753uncocked
uncoded11312743unco_ded
uncoerced1445313uncoerced
uncoiled112512683uncoiled
uncoined111813023uncoined
uncombed1536323uncombed
uncooked15269113uncooked
uncooled112710633uncooled
uncorseted1345153uncorseted
uncounted1238513uncounted
uncrated11416313uncrated
uncurbed1346903uncurbed
uncured10513233uncur_ed
uncurled1168963uncurled
uncursed1148963uncursed
undated93118463un_dated
undented102313953undented
underfed13311713underfed
undistorted1353053undistorted
undocked16277633undocked
undoubted1344453undoubted
undried92314603un_dried
unearned9310063unearned
unearthed1345573unearthed
unedited10249833unedited
unfelted1279403unfelted
unfired112212453unfir_ed
unfitted1238163unfitted
unfluted1237173unfluted
unfoiled12249723unfoiled
unfolded1338313unfolded
unforested1444803unforested
unfreed11510123un_freed
unfurled1277203unfurled
ungarbed12197063ungarbed
ungated92717213un_gated
ungifted13116833ungifted
ungirded1136083ungirded
ungotten944533ungotten
ungowned1335183ungowned
unharmed1438093unharmed
unhatted1238183unhatted
unheated121514553unheated
unhired112512153unhir_ed
unhooded13277873unhooded
unhooked16286743unhooked
unhoped13249353unho_ped
unhorse1038583unhorse_
unhorses1138453unhorses
unhoused1238143unhoused
uniformed1544533uniformed
unironed939083unironed
united74421543un__ited
unjoined16248443unjoined
unjointed1755583unjointed
unknotted1443613unknotted
unletted9310313unletted
unlisted9311143unlisted
unloaded1049533unloaded
unlobed10219743unlo_bed
unlocated1238383unlocated
unlocked15268383unlocked
unloosed9117523unloosed
unloved112310533unlo_ved
unmarked15248813unmarked
unmarred11258403unmarred
unmated103317023un_mated
unmatted1138293unmatted
unmelted1169183unmelted
unmerited1239643unmerited
unmitred1136843unmitred
unmolded1237453unmolded
unmolten1044933unmolten
unmoored1137333unmoored
unmortised1343983unmortised
unmounted1245903unmounted
unmourned1254153unmourned
unmoved13248903unmo_ved
unnerved1248063unnerved
unoiled82415473un_oiled
unowned1148803un_owned
unpitted1148623unpitted
unpointed1237153unpointed
unpoised1139173unpoised
unpolled1168943unpolled
unposed10711903unpo_sed
unprobed1366973unprobed
unproved1457533unproved
unpurged1236293unpurged
unquoted1836533unquoted
unrated82621553un_rated
unrented92413923unrented
unreported1344073unreported
unrested91914513unrested
unroasted1036613unroasted
unrobed102711213unro_bed
unrolled9610413unrolled
unroofed12106773unroofed
unroped102812103unro_ped
unrusted92310353unrusted
unsaved113312193uns_aved
unsawed112911503uns_awed
unscaled111410113unscaled
unscarred1235673unscarred
unscathed1535313unscathed
unscented1237513unscented
unscrew1245463unscr_ew
unscrewed1554033unscrewed
unscripted1544633unscripted
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseeded1038253unseeded
unseized1838433unseized
unsettled1055213unsettled
unsewed112911023uns_ewed
unsexed152410253uns_exed
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshared121510703unshared
unshaved15157733unshaved
unshed10313773uns__hed
unshifted16124943unshifted
unsighted1455423unsighted
unsigned1037553unsigned
unsized172510533uns_ized
unslaked1338463unslaked
unsliced1138083unsliced
unsmoked1536013unsmoked
unsmoothed1642003unsmoothed
unsnarled1035743unsnarled
unsober967633unso_ber
unsold71410513unso__ld
unsolder937213unsolder
unsolid8138373unso_lid
unsound8158433unso_und
unsounded1135533unsounded
unspoiled12255553unspoiled
unspooled12254913unspooled
unsprayed1554363unsprayed
unstarred1036363unstarred
unstate71916213unstate_
unstates81314993unstates
unstayed12168393unstayed
unstep839223uns__tep
unstinted1038553unstinted
unstocked1645063unstocked
unstoned9311043unstoned
unstopped1444403unstopped
unstriped1246293unstriped
unsupported1651353unsupported
unsure62815413unsur_e_
unswathed1634543unswathed
unswayed15155713unswayed
unswore1039053unswor_e_
untasted92011573untasted
untented92613413untented
untested92612413untested
untilted9610893untilted
untired82316383untir_ed
untried82615853un_tried
untufted1236083untufted
unturned9228563unturned
ununited938683ununited
unurged939143un_urged
unvaried1239683unvaried
unversed122310433unversed
unvested122210223unvested
unvoiced14106303unvoiced
unwanted12249603unwanted
unwarmed1437303unwarmed
unwarned1238453unwarned
unwarped1436873unwarped
unwasted12259783unwasted
unwetted1238123unwetted
unwitted1237543unwitted
unwooded13207443unwooded
unwooed11229773unwo_oed
unworried1344013unworried
unworthy1743133unworthy
unyoked1567123unyo_ked
unzoned172310653unzo_ned
updarted1244313updarted
uprooted1186393uprooted
upsoared11154353upsoared
upstarted1244213upstarted
upsurged12124043upsurged
usurped1035153u_surped
visored1138143visor_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.1561145455.1
2DLD Change Limit1461623347.39319770.3
3Display Results3343340.1402385.7
 (SQL Overall)1786913347.68923239.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.