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

104 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
unissued93468(None) 
issued746722__issued
reissued944902reissued
tissued835582_tissued
unassured1084352unassured
unimbued1343072unimbued
uninsured1044872uninsured
unkissed1334892unkiss_ed
aniseed839403ani_seed
blissed10388373bliss_ed
dissed85220183_diss_ed
disused93211033_disused
enisled82510223eni_sled
ensued73610483en__sued
fissured1235183_fissured
hissed104114453_hiss_ed
insisted998673insisted
issue559213__issue_
issuer646623__issuer
issues648803__issues
kissed114412853_kiss_ed
miscued1239293_miscued
missed94423603_miss_ed
misused104111283_misused
nonissue843963nonissue_
nonissues943733nonissues
pissed94816933_piss_ed
prissed103311263priss_ed
punished1436043puni_shed
reissue745873reissue_
reissuer854523reissuer
reissues845993reissues
tissue637333_tissue_
tissues737463_tissues
tissuey1033663_tissuey
unabused1135623unabused
unamused1135793unamused
unargued1035583unargued
unasked122010023un_asked
unassayed1343493unassayed
unassuaged1242403unassuaged
unbased103513483unbas_ed
unbasted112510073unbasted
unbiased1147153unbias_ed
unbiassed1243553unbiassed
unbusted11258773unbusted
uncased104216953uncas_ed
uncashed14299763uncashed
uncasked15278453uncasked
uncaused1138453uncaused
undisputed1442313undisputed
unensured1044943unensured
unessayed1342943unessayed
unfished15218293unfished
unfused11319513unfus_ed
unglued937303un_glued
unhoused1238153unhoused
unhusked1634603unhusked
unideaed1045733unideaed
unified112413573uni_fied
unilobed1136393unilobed
uninjured1743353uninjured
uninsureds1151763uninsureds
unique1558163uni_que_
uniquer1675783uni_quer
uniques1667443uni_ques
unironed939083unironed
unisex1358353uni_s_ex
unisexes1554613unisexes
unisize1647343unisize_
united74421543uni__ted
unitized1839233unitized
unlashed12289183unlashed
unlisted9311153unlisted
unmasked15267143unmasked
unmeshed1437003unmeshed
unposed10711903unpos_ed
unposted1159433unposted
unrested91914513unrested
unrinsed938383unrins_ed
unrushed12247573unrushed
unrusted92310353unrusted
unsated83419933un_sated
unsaved113312193un_saved
unsawed112911503un_sawed
unsewed112911023un_sewed
unsexed152410253un_sexed
unshed10313773un__shed
unsifted12128773unsifted
unsigned1037563unsigned
unsized172510543un_sized
unsound8158433un_sound
unsoured9310063un_soured
unsowed112511053un_sowed
untasted92011573untasted
untested92612413untested
unused72012883un_us_ed
unvalued1266313unvalued
unvested122210223unvested
unvisited1345173unvisited
unwashed15288483unwashed
unwasted12259783unwasted
unwished15237833unwished
wissed104114643_wiss_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.420425454.8
2DLD Change Limit1461621047.06320694.0
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.52923733.7
 
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.