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

221 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
unsolved123783(None) 
absolved1443132absolved
involved1534342involved
resolved12349342resolved
solved105312932__solved
unbolted1179322unbolted
unevolved1643082unevolved
unfolded1338312unfolded
ungloved1335602ungloved
unhalved1556512unhalved
unloved112310532unlo_ved
unmolded1237452unmolded
unmoved13248902unmo_ved
unpolled1168942unpolled
unresolved1442652unresolved
unrolled9610412unrolled
unsalted9510922unsalted
unsaved113312192uns_aved
unserved12410232unserved
unshaved15157732unshaved
unsoaked1338852unsoaked
unsoiled92412082unsoiled
unsold71410512unsol__d
unsolder937212unsolder
unsolid8138372unsol_id
unsorted9312512unsorted
unsoured9310062unsoured
unsowed112511052unso_wed
absolve1244513absolve_
absolver1343693absolver
absolves1344413absolves
consoled112911453consol_ed
convolved1844083convolved
devolved16325513devolved
dissolved1445593dissolved
enfolded1345433enfolded
enrolled967973enrolled
ensiled82611433ensil_ed
enslaved1245063enslaved
ensouled935833ensouled
evolved14305583_evolved
infolded1375663infolded
insolated1039713insolated
insole63515863insol_e_
insoles73516243insol_es
insolvent12136123insolvent
insouled936113insouled
insulted937193insulted
involve1345093involve_
involver1444663involver
involves1444973involves
knolled12296573kn_olled
presolved1545273presolved
resoled84119283resol_ed
resolve103910983resolve_
resolver11339793resolver
resolves113010783resolves
revolved15328103revolved
salved103916423__salved
snooled84513943snool_ed
soled65835173__sol_ed
soloed74515743__soloed
solve85618943__solve_
solver94016703__solver
solves95018223__solves
unallied938393unallied
unbaled103315963unbal_ed
unbeloved1543923unbeloved
unbelted1179333unbelted
unbilled1188693unbilled
unbobbed1234413unbobbed
unbodied1237263unbodied
unboiled112410373unboiled
unbonded12299763unbonded
unboned103014223unbo_ned
unbooted1188773unbooted
unbowed132610243unbo_wed
unboxed17249573unbo_xed
uncalled11810923uncalled
uncarved1438163uncarved
unclosed111010513unclosed
uncloyed1487343uncloyed
uncoated11314963uncoated
uncocked17248753uncocked
uncoded11312743unco_ded
uncoiled112512683uncoiled
uncoined111813023uncoined
uncolored1246963uncolored
uncombed1536323uncombed
uncooked15269113uncooked
uncooled112710633uncooled
uncorked152210403uncorked
uncover1239003unco_ver
undissolved1651403undissolved
undocked16277633undocked
undotted1048523undotted
undulled1036993undulled
unfelted1279403unfelted
unfilled1298383unfilled
unfilmed1495803unfilmed
unfoiled12249723unfoiled
unfold10179703unfol__d
unfolder12216583unfolder
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unformed14239573unformed
ungalled1078463ungalled
ungelded1147403ungelded
unglove1136103unglove_
ungloves1245293ungloves
unglued937303un_glued
ungowned1335183ungowned
unhelmed1435993unhelmed
unhelped1435923unhelped
unholier1137283unholier
unhooded13277873unhooded
unhooked16286743unhooked
unhoped13249353unho_ped
unhorsed1238833unhorsed
unhoused1238153unhoused
unilobed1136393unilobed
uninvolved1752173uninvolved
univalved1643483univalved
unjoined16248443unjoined
unled64021073un__l_ed
unlived112511373un_lived
unloaded1049533unloaded
unlobed10219743unlo_bed
unlocked15268383unlocked
unloosed9117523unloosed
unmelted1169183unmelted
unmilled1197853unmilled
unmold9148313unmol__d
unmolten1044933unmolten
unmoored1137333unmoored
unnerved1248063unnerved
unnoted8311363unno_ted
unoiled82415483un_oiled
unowned1148813un_owned
unpaved133410053un_paved
unpiled102312743unpil_ed
unplowed1436353unplowed
unpoised1139183unpoised
unpoliced1445163unpoliced
unposed10711903unpo_sed
unposted1159433unposted
unpotted11108393unpotted
unproved1457533unproved
unreeved12117673unreeved
unrobed102711213unro_bed
unroofed12106773unroofed
unrooted9810513unrooted
unroped102812113unro_ped
unrove92511683unro_ve_
unroven10238143unro_ven
unruled8311373unrul_ed
unsated83419933uns_ated
unsawed112911513uns_awed
unscaled111410113unscaled
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unseeded1038253unseeded
unseized1838443unseized
unsewed112911023uns_ewed
unsexed152410253uns_exed
unshaded13149263unshaded
unshamed14148053unshamed
unshaped14148443unshaped
unshared121510703unshared
unshaven14154883unshaven
unshed10313773uns__hed
unshelled1336573unshelled
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543uns_ized
unskilled1444603unskilled
unslaked1338463unslaked
unsliced1138093unsliced
unsmoked1536013unsmoked
unsober967643unso_ber
unsoldered1243583unsoldered
unsolders1064693unsolders
unsoothed1344253unsoothed
unsound8158433unso_und
unsounded1135543unsounded
unsourced1244833unsourced
unspilled1245093unspilled
unspoiled12255563unspoiled
unspooled12254913unspooled
unspotted1244933unspotted
unstalked1435523unstalked
unstated91615813unstated
unstayed12168393unstayed
unstocked1645063unstocked
unstoned9311043unstoned
unstopped1444403unstopped
unsuited9310793unsuited
unsullied1044543unsullied
unswayed15155713unswayed
unswollen1242623unswollen
untilled9710563untilled
untilted9610893untilted
untold7149683untol__d
unvalued1266313unvalued
unvoiced14106303unvoiced
unwalled1288653unwalled
unwelded1337143unwelded
unwilled1277823unwilled
unwonted12248643unwonted
unwooded13207443unwooded
unwooed11229773unwo_oed
unworked16238503unworked
unwove12238883unwo_ve_
unwoven13176673unwo_ven
unyoked1567123unyo_ked
unzoned172310653unzo_ned
upfolded1542883upfolded
upsoared11154353upsoared

Search took 9 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.420425454.8
2DLD Change Limit1461622217.69019006.8
3Display Results2212210.0932376.3
 (SQL Overall)1786912218.20321783.6
 
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.