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

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

103 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
cursoriness134327(None) 
cursorinesses1553282cursorinesses
crustiness1237263crus_tiness
curarines11710543cur_arine_s
curiousness1348973curiousness
curliness1138553cur__liness
cursedness1344463curs_edness
cursiveness1647063cursiveness
cushiness14197183cu_s_hiness
furriness12287593fur__riness
pursiness1138453purs__iness
blurriness1243484blur__riness
broodiness1344654_broodiness
burliness1137834bur__liness
bursaries1157634bursari_e_s
bushiness14177754bu_s_hiness
business102110684bu_s__iness
bustiness111810464bu_s_tiness
chariness14310064c__hariness
cheeriness1545534c_heeriness
chlorines142512354c_hlorine_s
chorines132917254c__horine_s
churchliness2251604churchliness
classiness12196314clas_siness
clumsiness1444334clums__iness
corkiness152810444cor__kiness
corniness112611184cor__niness
cosiness103214284c___osiness
costliness1245984c_ostliness
courtliness1343904cour_tliness
coziness19319824c___oziness
craftiness1545744c_raftiness
cragginess1444144c_ragginess
crankiness1636174c_rankiness
craziness2037384c_r_aziness
creakiness1645964c_reakiness
creaminess1446204c_reaminess
creepiness1444884c_reepiness
crispiness1444794c_rispiness
crossness1137094c_r_ossness
crumbliness1742574crumbliness
crumminess1643684c_rumminess
crunchiness1843284crunchiness
cuisines1049374cuis__ine_s
curableness1547304curableness
curarine10610704cur_arine__
curarizes2078174cur_arize_s
currentness1352824currentness
curriers103410754cur__ri_ers
curries93723164cur__ri_e_s
cursives1337104curs__ive_s
cursorial1144604cursori__al
cursorily1442924cursori__ly
cursors93910024cursor____s
curtainless1351934cur_tainless
curtness1037264cu___rtness
cussedness1342844cu_ssedness
customariness1761574customariness
dreariness1146284_dreariness
duskiness14216674du_s_kiness
dustiness102211024du_s_tiness
forlornness1452134forlornness
frostiness1336564_frostiness
fulsomeness1652814fulsomeness
furriners12316304fur__riners
fussiness12226584fu_s_siness
fustiness121910244fu_s_tiness
goriness9310754___goriness
gushiness13206854gu_s_hiness
gustiness10189894gu_s_tiness
gutsiness10226964guts__iness
horsiness12259464hors__iness
hungriness1443174hu_ngriness
huskiness16206574hu_s_kiness
illusoriness1262094illusoriness
lustiness92010454lu_s_tiness
marshiness1555064mars_hiness
merriness1138284mer__riness
murkiness15206284mur__kiness
mushiness14248214mu_s_hiness
muskiness15237434mu_s_kiness
mussiness11238294mu_s_siness
mustiness112211654mu_s_tiness
nurseries948004nurseri_e_s
orneriness1045444_orneriness
prosiness11311674_pr_osiness
purloiners1242814purlo_iners
pushiness14197284pu_s_hiness
roominess1157294__roominess
rootiness979064__rootiness
ropiness102311074__r_opiness
rosiness82613174__r_osiness
rustiness92111924ru_s_tiness
savoriness1354934_savoriness
scurviness1543284scur__viness
soreness8914794___soreness
sorriness939584___sorriness
sultriness1045564su_ltriness
surliness939944sur__liness
tarriness9229244tar__riness
trustiness1036624trus_tiness
unholiness1344984_unholiness
unwariness1365884_unwariness

Search took 10 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 Filter1786911488190.1701051123.5
2DLD Change Limit1488191039.23616112.9
3Display Results1031030.0931107.5
 (SQL Overall)1786911039.49918811.6
 
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.