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 “raised” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 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
raised7612033(None) 
braised104014801braised
praised104214811praised
raided85017701raided
railed74727541railed
rained75024601rained
raise54828051raise_
raiser66620101raiser
raises64826541raises
rased65033931ra_sed
aided75828932_aided
ailed66240282_ailed
aimed85626052_aimed
aired66032922_aired
aisled74516182_aisled
ariled75620322ariled
arise56436432arise_
arisen65316792arisen
arises65233802arises
axised14438962axised
bailed94726652bailed
baited95319242baited
based85331582ba_sed
biased94012222biased
braided114013212braided
brailed103914012brailed
brained103816102brained
braise84318752braise_
braises93818872braises
brassed103612372brassed
bruised10389502bruised
cased86032412ca_sed
caused95117042caused
cruised103710212cruised
daises74318982daises
daisied93410012daisied
drained93713252drained
eased65430402ea_sed
erased74816752era_sed
failed105421602failed
faired105915772faired
fraise94214912fraise_
fraises104215692fraises
gained84617462gained
gaited84416922gaited
gassed85217632gassed
grained93814272grained
grassed93812792grassed
guised84612172guised
hailed104122742hailed
haired105117172haired
hoised105117432hoised
irised73913152irised
jailed144917422jailed
kaiser103610372kaiser
laired75216812laired
lapsed94712582lapsed
lased65132342la_sed
liaised837112liaised
mailed95326752mailed
maimed114812662maimed
massed94421322massed
nailed74021492nailed
noised75416232noised
paiked135113432paiked
pained95622852pained
paired95017522paired
paise75028332paise_
parsed96323892parsed
passed94320942passed
paused95114962paused
peised94817682peised
poised94918472poised
praise84419412praise_
praiser93413942praiser
praises94121102praises
prised94322202prised
raced87635312ra_ced
racked134526082racked
radded94716492radded
radioed939672radioed
rafted104714702rafted
raged74829452ra_ged
ragged94620262ragged
raid55243072rai__d
raider74318742raider
railer64524932railer
rais45252622rais__
raisers73617392raisers
raisin62716922raisin
raked105831422ra_ked
rammed113117302rammed
ramped114617902ramped
ranged84824312ranged
ranked114620742ranked
ranted74324702ranted
raped85334622ra_ped
rapped114122682rapped
rared65738322ra_red
rase46149982ra_se_
raser55633412ra_ser
rases55447212ra_ses
rasped94715202rasped
rassled83310452rassled
rated65441382ra_ted
ratted74923342ratted
raved94931432ra_ved
ravined115411822ravined
ravished1555712ravished
raxed135622662ra_xed
rayed95127502ra_yed
razed155027982ra_zed
razeed163710012razeed
razzed15478282razzed
realised92214532realised
reined74425522reined
reived104518132reived
remised103516842remised
reraised9312352reraised
reused75419562reused
revised113815482revised
riced85825542r_iced
riled65833252r_iled
rimed84826372r_imed
rinsed75016352rinsed
riped85226432r_iped
rise45945232r_ise_
risen54621882r_isen
riser55431052r_iser
rises55244042r_ises
risked115514632r_isked
rived94825612r_ived
roiled74320052roiled
roosed75621592roosed
rosed65930342r_osed
roused75426442roused
ruined74813322ruined
sailed74327762sailed
sained75424242sained
sassed76116172sassed
seised74218122seised
tailed74424662tailed
tawsed10499742tawsed
traiked123310452traiked
trailed83415672trailed
trained84117202trained
traipsed1134752traipsed
unraised91811882unraised
upraised11167412upraised
vailed104619292vailed
vised95518762_vised
waifed134011032waifed
wailed104823592wailed
waired106015832waired
waisted114210942waisted
waited103819772waited
waived134511282waived
wised95123342_wised

Search took 4 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 Filter178691825510.203880251.2
2DLD Change Limit825511582.84329036.6
3Display Results1581580.0463434.8
 (SQL Overall)1786911583.09257791.4
 
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.