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

102 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
ultrared93666(None) 
ultrareds1044081ultrareds
cultrated1248222cultrated
untraced112413242untraced
altered83215733alt_ered
betrayed1436303betrayed
blared95018243bl__ared
bleared104211253bl_eared
blurred10427803blur_red
citrated112712243citrated
cleared103612463cl_eared
cultrate10310873cultrate_
cultured1137233cult_ured
estrayed1236393estrayed
filtrated1345963filtrated
flared105317603fl__ared
glared84715193gl__ared
infrared1236193infrared
lustrated1037963lustrated
lyrated11388473_lyrated
mortared1137213mortared
multiarmed1554643multiarmed
nitrated92213153nitrated
outdared102711513outdared
outraced112414203outraced
outraged102313093outraged
outrated92219313outrated
outraved122511923outraved
outroared10158113outroared
outtraded1176983outtraded
rared65738323___rared
retraced111413023retraced
slurred8359183slur_red
stared75429873_st_ared
starred85013453_starred
strafed114413323_strafed
straked125415343_straked
strawed114813613_strawed
strayed114513283_strayed
tared69340053__t_ared
tarred74720283__tarred
teared75722153__teared
titrated92611683titrated
traced94821583__traced
traded85717683__traded
ulcerated1247743ulcerated
ulcered1037973ul_cered
ullaged937033ul_laged
ultimated1247303ultimated
ultra539363ultra___
ultracold1253593ultracold
ultradry1243143ultradry
ultraheat1255753ultraheat
ultrahip1343843ultrahip
ultrahot1145703ultrahot
ultraism1046943ultraism
ultraist849633ultraist
ultraleft1254753ultraleft
ultralow1143193ultralow
ultrapure1153833ultrapure_
ultrarapid1353733ultrarapid
ultrarare954463ultrarare
ultrarich1455393ultrarich
ultras6310183ultra__s
ultrawide1344013ultrawide
ululated947663ululated
unbarred11238703unbarred
unbeared111611653unbeared
unbraced132310433unbraced
unbraked15289413unbraked
uncrated11416313uncrated
undraped1239393undraped
unerased9312773unerased
unfeared121511013unfeared
unframed1478243unframed
ungraced12239143ungraced
ungraded11209923ungraded
unmarred11258403unmarred
unraked122914013u_nraked
unrated82621553u_nrated
unrazed172511453u_nrazed
unseared91113943unseared
unshared121510703unshared
unstarred1036363unstarred
untamed102913223unt_amed
untaxed152710583unt_axed
unthawed1535583unthawed
untired82316383unt_ired
untracked16228373untracked
untrained10510993untrained
untrapped14106123untrapped
untreaded1137983untreaded
untreated10312903untreated
untried82615853untr_ied
upgraded13215683upgraded
uprated103213323u_prated
upreared1137073upreared
upsoared11154353upsoared
upstared11156573upstared
urare56322553u__rare_
urares64519093u__rares
uttered82712433u_ttered

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.1701051123.5
2DLD Change Limit1461621028.40617387.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911028.62220725.0
 
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.