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

212 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
unrisen722928(None) 
uprisen9227351uprisen
arisen65316792_arisen
rerisen73613642rerisen
risen54621882__risen
sunrise7310812sunrise_
sunrises8310692sunrises
unisex1358352un_isex
unison649032un_ison
unraised91811882unraised
unrimed102211632unrimed
unrinsed938382unrinsed
unripe82012092unripe_
unriper9188282unriper
unroven10238142unroven
unwise9510802unwise_
unwiser1037122unwiser
uprise82313692uprise_
upriser9218762upriser
uprises92012732uprises
anise55129703an_ise_
anises64826693an_ises
antigen8311123antigen
antisex1439693antisex
arise56436433_arise_
arises65233803_arises
arrises71617583arrises
brises84927613_brises
cerise84822043cerise_
cerises94722253cerises
christen13106703christen
crises84529433_crises
crispen11348203_crispen
driven105210143_driven
enliven1034903enliven
frise85322453_frise_
frisee94217993_frisee
frises94124273_frises
greisen856503greisen
grison7310103_grison
hubrises1337103hubrises
incise83515333incise_
incised102911583incised
incises93414893incises
indigen9319333indigen
irised73913153_irised
irises64221173_irises
krises105016083_krises
lorises73918593lorises
merises93421423merises
nisei54214353_n_isei
noise55723733_noise_
noised75416233_noised
noises65021853_noises
nurse54420123nur_se_
nursed74514663nur_sed
nurser64314503nur_ser
nurses63919353nur_ses
orison6411663_orison
orrises71312233orrises
parises94827183parises
prise74632613_prise_
prised94322203_prised
prises84133173_prises
prison8514023_prison
rerise64325633rerise_
rerises73525883rerises
ripen75619263__ripen
rise45945233__rise_
riser55431053__riser
rises55244043__rises
riven85121623__riven
samisen937673samisen
sarsen6314233sar_sen
shriven13379653shriven
striven103910753striven
sunwise1036433sunwise_
thriven13447023thriven
unaided92414603unaided
unaimed102812493unaimed
unaired82916013unaired
unais53420773unais__
unbased103513483unbased
unbiased1147153unbiased
unbidden1263573unbidden
unbitten1045213unbitten
unbroken14235073unbroken
unbruised1244763unbruised
uncase83817433uncase_
uncased104216953uncased
uncases93516553uncases
unchosen1356283unchosen
unciae83215313unciae_
undies73821963undi_es
undine7817263undine_
undines8716083undines
undried92314613undri_ed
unease63816643unease_
uneases73316263uneases
uneaten7412543uneaten
unerased9312773unerased
uneven957913un_even
unfasten1144843unfasten
unfired112212453unfired
unfished15218293unfished
unfixed18218563unfixed
unfixes17238113unfixes
unfrozen2043753unfrozen
unfused11319513unfused
unhired112512153unhired
union54519793un_i_on
unisons748423un_isons
unite54828383un_ite_
united74421543un_ited
uniter64619143un_iter
unites65024853un_ites
unkissed1334893unkissed
unladen8248653unladen
unlike102614063unlike_
unliked122411283unliked
unlined82515803unlined
unlisted9311153unlisted
unlive92712333unlive_
unlived112511373unlived
unlives102010953unlives
unloosen8125263unloosen
unmined102612953unmined
unmiter9310393unmiter
unmixed17228213unmixed
unmixes16197753unmixes
unoiled82415483unoiled
unopen838913un_open
unpen72913573un__pen
unpile81914323unpile_
unpiled102312743unpiled
unpiles92112783unpiles
unpin72613243unpi__n
unpoised1139183unpoised
unposed10711903unposed
unpriced1338143unpriced
unprimed1337203unprimed
unprized2038513unprized
unproven1365463unproven
unraked122914013unraked
unrated82621553unrated
unravel1038063unravel
unrazed172511453unrazed
unreason8104483unreason
unreel63612933unr_eel
unrent63219783unr__ent
unrest62918853unres_t
unrested91914513unrested
unrests7229463unrests
unrevised1345163unrevised
unribbed1334173unribbed
unrifled1237423unrifled
unrig61711413unri__g
unrigged1165643unrigged
unrigs7159003unri_gs
unrip72012863unri__p
unripely1344633unripely
unripened1244393unripened
unripest1046083unripest
unripped1335763unripped
unrips8199453unri_ps
unrobe82611673unrobe_
unrobed102711213unrobed
unrobes9269733unrobes
unroped102812103unroped
unrove92511683unrove_
unruled8311373unruled
unrushed12247573unrushed
unrusted92310353unrusted
unseen62012623un_seen
unsent63820963un__sent
unset54532433un__set
unsew83912693un__sew
unsewn9298393un__sewn
unsex123512633un__sex
unsilent849603unsilent
unsized172510543unsized
untaken1137643untaken
untie54425493unti_e_
untied73720813unti_ed
unties64326923unti_es
untimed102713373untimed
untired82316383untired
untried82615853untri_ed
unused72012883un_used
unwisely1444463unwisely
unwisest1165123unwisest
unwish1239093unwis_h
unwished15237833unwished
unwishes14147483unwishes
unwoven13176673unwoven
unwritten1243143unwritten
upraise9158603upraise_
upraised11167413upraised
upraiser10175843upraiser
upraises10188473upraises
uprisers10206773uprisers
uprising1138953uprising
upriver12196933upriver
uprose82311483uprose_
urase54624693u_rase_
urases63723563u_rases
urine55026593u_rine_
urines64724123u_rines
ursine64114123u_rsine
uruses63616503u_ruses
warison1037083warison
worsen95513873wor_sen

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272125.79623124.1
3Display Results2122120.0762789.5
 (SQL Overall)1786912126.27828463.0
 
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.