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

244 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
raisiny1031992(None) 
raisin62716921raisin_
raising83220531raising
raisins72715341raisins
arising83619972arising
braising113014562braising
praising113214562praising
raiding93617592raiding
railing83325642railing
rainily10310432rainily
raining83922692raining
rainy85921082ra__iny
raisings9338442raisings
rasing74330832ra_sing
resiny94617362r_esiny
rising74025882r_ising
rosiny94414532r_osiny
aiding84423613_aiding
ailing74331013_ailing
aiming94320843_aiming
airily93014823_airily
airing74927503_airing
arcsine94512393arcsine
aridity11510113aridity
arisen65316793arisen_
arsine64021043_arsine
arsino64113513_arsino
bailing103723523bailing
baiting103918883baiting
basify1437513ba_sify
basin75026923ba_sin_
basing95427663ba_sing
basins85722763ba_sins
biasing103512453biasing
braiding123112703braiding
brailing113514793brailing
brainily1337313brainily
braining113414683braining
brainy114815643bra__iny
brassily1336623brassily
brassing112612303brassing
bruising11279143bruising
cairny11557823cai_rny
casing94829103ca_sing
casini84615863ca_sini
casino84317553ca_sino
cassina94113163cassina
cassine93817283cassine
cassino93512433cassino
causing103614413causing
criminy14268453criminy
cruising112610153cruising
cuisine9310423cuisine
daisied93410013daisied
daisies84217093daisies
daisy95915313dais__y
draining103312673draining
easily9313023ea_sily
easing74926463ea_sing
erasing8317953era_sing
failing113521333failing
fairing113614013fairing
falsify1643613falsify
falsity1335903falsity
gaijin1445973gaijin_
gaining94015663gaining
gaiting93716583gaiting
gasify1336333ga_sify
gassily1137813gassily
gassing94216333gassing
graining102813183graining
grainy103914213gra__iny
grassily1236433grassily
grassing103311973grassing
guising93511413guising
hailing113820693hailing
hoising113414413hoising
irising83614423irising
jailing153415843jailing
jiminy1836273_jiminy
kamsin1238323kamsin_
kamsins1346963kamsins
lairing83715343lairing
lapsing103511163lapsing
lasing74727983la_sing
liaising937913liaising
mailing102923343mailing
maiming122912723maiming
massing104318023massing
nailing83419963nailing
noisily1038403noisily
noising83615173noising
paiking143814813paiking
paining103920243paining
pairing103716733pairing
paisan84417073paisan_
paisana94010223paisana
paisano9429513paisano
paisans93614753paisans
paisley1235553paisley
parsing103819553parsing
passing104318423passing
pausing103912813pausing
peising103416763peising
poising103617103poising
prising103321453prising
rabbin103112303rabbin_
rabbins112811343rabbins
rabbity14266303rabbity
rabidity1446583rabidity
racily11715173ra_cily
racing95030533ra_cing
racking144323663racking
radding103715003radding
radioing1039383radioing
rafting113815753rafting
ragging103516683ragging
raging85126433ra_ging
railings93412153railings
railway1345313railway
raiment9315413raiment
rain46251733ra__in_
rainier71614253rainier
rains55140233ra__ins
rais45252623rais___
raise54828053rais__e
raised76120333rais_ed
raiser66620103rais_er
raisers73617393raisers
raises64826543rais_es
raisonne843813raisonne
raking114728413ra_king
rakishly1844293rakishly
ralline73518413ralline
ramify14268753ra_mify
ramming123115063ramming
ramosity1345893ramosity
ramping123316873ramping
ramson8310463ramson_
ramsons939563ramsons
ranging94120263ranging
ranking124320883ranking
ranting84025413ranting
rapidity1446273rapidity
rapine85023083ra_pine
raping94829853ra_ping
rapini84714683ra_pini
rapping123619103rapping
rappini11347573rappini
rarify123210063ra_rify
raring74332873ra_ring
rarity93615493ra_rity
rashly123410213ra_shly
rasping104316253rasping
raspy106511703ra_s_py
rassling939013rassling
ratany93411873ra_tany
ratfink1434943ratfink
ratify122610043ra_tify
ratine65131823ra_tine
rating74938703ra_ting
ratlin64116523ratlin_
ratline74517803ratline
ratlins73615583ratlins
ratting83822363ratting
raucity1235853raucity
ravin85624653ra_vin_
ravine95522223ra_vine
raving105128853ra_ving
ravining12269693ravining
ravins94622563ra_vins
ravishing1634983ravishing
rawin85521473ra_win_
rawins95617623ra_wins
raxing144321023ra_xing
raying105027193ra_ying
razing164524543ra_zing
razzing1636323razzing
realising10313173realising
reining84425323reining
reiving113316843reiving
remising112516453remising
reraising10313773reraising
rerising93017783rerising
resin54131053r_esin_
resins64528773r_esins
retsina74710603retsina
reusing82516783reusing
revising122714403revising
ricin74620213r_icin_
ricing94822763r_icing
ricins83618703r_icins
riding84325963r_iding
riling74227973r_iling
riming93322223r_iming
rinsing82516113rinsing
riping93821613r_iping
risen54621883r_isen_
risibly1235643r_isibly
risings83211893r_isings
riskily1436413r_iskily
risking123914243r_isking
risky126311523r_is_ky
riving104521423r_iving
roiling83220453roiling
roosing84018133roosing
rosily93914713r_osily
rosin55325313r_osin_
rosing73925593r_osing
rosins64521863r_osins
rousing83920553rousing
ruining83514883ruining
rusine63916593r_usine
russify1334063russify
sailing83927373sailing
saimin8313663saimin_
saimins9312113saimins
saining83621393saining
salsify1334703salsify
sasin54626573sa_sin_
sasins64923103sa_sins
sassily1038723sassily
sassing84615553sassing
satiny93817983sa_tiny
seisin63715123seisin_
seising84018863seising
seisins73614393seisins
tailing82923103tailing
tawsing1138673tawsing
traiking132511973traiking
trailing92916093trailing
training93015863training
traipsing1235063traipsing
upraising1237263upraising
vailing113817943vailing
varsity1356673varsity
vising103915873_vising
waifing142910893waifing
wailing113620903wailing
wairing113414313wairing
waisting123615213waisting
waiting113618953waiting
waiving14329633waiving
wising103318223_wising

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340272448.08016587.5
3Display Results2442440.0763210.5
 (SQL Overall)1786912448.30921505.7
 
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.