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

132 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
raising8322053(None) 
arising83619971arising
braising113014561braising
praising113214561praising
raiding93617591raiding
railing83325641railing
raining83922691raining
raisin62716921raisin_
raisings9338441raisings
raisins72715341raisins
raisiny10319921raisiny
rasing74330831ra_sing
rising74025881r_ising
aiding84423612_aiding
ailing74331012_ailing
aiming94320842_aiming
airing74927502_airing
bailing103723522bailing
baiting103918882baiting
basing95427662ba_sing
biasing103512452biasing
braiding123112702braiding
brailing113514792brailing
braining113414682braining
brassing112612302brassing
bruising11279142bruising
casing94829102ca_sing
causing103614412causing
cruising112610152cruising
draining103312672draining
easing74926462ea_sing
erasing8317962era_sing
failing113521332failing
fairing113614012fairing
gaining94015662gaining
gaiting93716582gaiting
gassing94216332gassing
graining102813182graining
grassing103311972grassing
guising93511412guising
hailing113820692hailing
hoising113414412hoising
irising83614422irising
jailing153415842jailing
lairing83715342lairing
lapsing103511162lapsing
lasing74727982la_sing
liaising937912liaising
mailing102923342mailing
maiming122912722maiming
massing104318022massing
nailing83419962nailing
noising83615172noising
paiking143814812paiking
paining103920242paining
pairing103716732pairing
parsing103819552parsing
passing104318422passing
pausing103912812pausing
peising103416762peising
poising103617102poising
prising103321452prising
racing95030532ra_cing
racking144323662racking
radding103715002radding
radioing1039382radioing
rafting113815752rafting
ragging103516682ragging
raging85126432ra_ging
railings93412152railings
raking114728422ra_king
ramming123115062ramming
ramping123316872ramping
ranging94120262ranging
ranking124320882ranking
ranting84025412ranting
raping94829852ra_ping
rapping123619102rapping
raring74332872ra_ring
rasping104316252rasping
rassling939012rassling
rating74938702ra_ting
ratting83822362ratting
raving105128852ra_ving
ravining12269692ravining
ravishing1634982ravishing
raxing144321022ra_xing
raying105027192ra_ying
razing164524542ra_zing
razzing1636322razzing
realising10313172realising
reining84425322reining
reiving113316842reiving
remising112516452remising
reraising10313772reraising
rerising93017782rerising
reusing82516782reusing
revising122714402revising
ricing94822762r_icing
riding84325962r_iding
riling74227972r_iling
riming93322222r_iming
rinsing82516112rinsing
riping93821612r_iping
risings83211892r_isings
risking123914242r_isking
riving104521422r_iving
roiling83220452roiling
roosing84018132roosing
rosing73925592r_osing
rousing83920552rousing
ruining83514882ruining
sailing83927372sailing
saining83621392saining
sassing84615552sassing
seising84018862seising
tailing82923102tailing
tawsing1138672tawsing
traiking132511972traiking
trailing92916092trailing
training93015862training
traipsing1235072traipsing
upraising1237262upraising
vailing113817952vailing
vising103915872_vising
waifing142910892waifing
wailing113620902wailing
wairing113414312wairing
waisting123615212waisting
waiting113618952waiting
waiving14329632waiving
wising103318222_wising

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 Filter1786911076710.376475242.0
2DLD Change Limit1076711323.07635003.6
3Display Results1321320.0462869.6
 (SQL Overall)1786911323.49851083.8
 
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.