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

172 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
crossly127727(None) 
crassly1276651crassly
grossly1175981grossly
closely1237052closely
cosily113613852c_osily
costly114012332c_ostly
cressy11439112cress_y
crisply14426522crisply
cross75124502cross__
crosse85216302cross_e
crossed105313892crossed
crosser95015462crosser
crosses94220792crosses
crosslet1049592crosslet
crossway1643852crossway
crousely1346562crousely
crusily12199092crusily
drossy10528472dross_y
erosely1038072erosely
prosily12611632prosily
rosily93914712_rosily
across8312643across__
bassly114610073_bassly
bossily1237563_bossily
bossy105515973_boss_y
brashly15427613brashly
brassily1336623brassily
brassy11509233brass_y
briskly16165403briskly
bristly12178063bristly
broadly1337153broadly
brolly114510853bro_lly
brosy106115383bro_s_y
choosey15459233choosey
choosy14459103choos_y
cissy104811073c_iss_y
classily1336623classily
classy11379043class_y
coaly105521593c_o_aly
coldly12459953c_oldly
colly104926773c_o_lly
coly96940533c_o__ly
comely134213733c_omely
comply152810383c_omply
coolly114811393c_oolly
cooly105525423c_o_oly
cornily12410853cornily
cosey106226713c_o_sey
coss66143493c_oss__
cosset84125863c_osset
cosy97232703c_o_s_y
coyly135614893c_o_yly
cozily20349703c_ozily
crackly18397703crackly
crankly16358123crankly
crass76328043crass__
crasser94114333crasser
crawly144610763cr_awly
crazily2136923crazily
creasy114612303creas_y
creosol946043creosol_
creosols1045713creosols
cresol8310203cresol_
cresols939643cresols
cress75022833cress__
cresses94219813cresses
cresset93319943cresset
cresyl1135133cresyl_
cresyls1234753cresyls
crinkly16387523crinkly
crispily1574693crispily
crispy13478563cr_ispy
crissa837623criss_a
crissal937413crissal
crissum1144843crissum
croakily1744733croakily
croaky15528483cro_aky
crocs95722433crocs__
crony105918673cro__ny
crops96125233crops__
crosier94116573crosier
crossable1347073crossable
crossarm1245123crossarm
crossbar1254483crossbar
crossbill1343733crossbill
crossbow1543043crossbow
crosscut1245253crosscut
crossers103912693crossers
crossest1012012123crossest
crossing112612683crossing
crosslets1145183crosslets
crosstalk1543893crosstalk
crosstie1046933crosstie
crosswalk1843003crosswalk
crossways1743413crossways
croupily1544743croupily
croupy13458733cro_upy
crouse84619363crous_e
crowdy15467173cro_wdy
crows105727313crows__
crudely1336273crudely
cruelly1236553cruelly
crumbly16347523crumbly
crumply16336093crumply
crustily13328173crustily
crusty114911343cr_usty
curiously1447673curiously
cymosely1842973cymosely
dressily1246443dressily
dressy10518143dress_y
drolly105411673dro_lly
drooly104911073dro_oly
dropsy12497473drops_y
droshky1841973droshky
drosky14486163dro_sky
dross65418093dross__
drosses84513823drosses
drowsily1583723drowsily
drowsy13487903drows_y
flossily1434523flossily
flossy12517703floss_y
freshly16286833freshly
frostily1436693frostily
frosty124710633fro_sty
frowsty16464983frowsty
frowsy15498273frows_y
ghostly14355103ghostly
glossily1235093glossily
glossy10549003gloss_y
grassily1236433grassily
grassy10619093grass_y
grisly104310583gr_isly
gristly11187333gristly
gross65421693gross__
grossed93812253grossed
grosser84313143grosser
grosses84517683grosses
groszy19395703gro_szy
growly13499173gro_wly
horsily1338843horsily
hostly124210863_hostly
loosely1036713loosely
lossy85214643_loss_y
morosely1345713morosely
mossy105217063_moss_y
mostly113110943_mostly
nosily93712683_nosily
piously1236833piously
porously1347753porously
poshly1437723_poshly
prissily1346693prissily
prissy11347853priss_y
pronely12310243pronely
prosody1336433prosody
pross76529403pross__
prosses94019513prosses
prossie91812953prossie
prosy106319253pro_s_y
proudly1336323proudly
pussly11407373_pussly
rashly123410213_rashly
rassle63813203_rassle
roily86121113_ro_ily
ropily113312443_ropily
rosary92810353_rosary
rosery93813283_rosery
rosiny94414533_rosiny
rosy76024873_ro_s_y
tressy9448553tress_y
trolly94012353tro_lly
wrassle10357173wrassle
wrongly1434553wrongly

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.1561145455.1
2DLD Change Limit1340271728.04616657.6
3Display Results1721720.0632730.2
 (SQL Overall)1786911728.26521620.2
 
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.