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

109 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
crankous143597(None) 
crankles143510152crankles
cranks125015312crank__s
crannogs1143782crannogs
uranous7310732uran_ous
ankus91410683__ank_us
araceous1049183araceous
arenous7314183aren_ous
branks124817383brank__s
cachous14312583c_achous
callous93516603c_allous
candors104216763c_andors
candour104210243c_andour
candours11408643c_andours
cankerous1566053c_ankerous
cankers134418753c_ankers
cannons94412883c_annons
canoes84725883c_an_oes
canons85522063c_an_ons
canorous10310193c_anorous
cansos84915383c_anso_s
canthus1248713c_anthus
cantons95221203c_antons
cantors94620753c_antors
cantos84826973c_anto_s
cantus85117763c_an_tus
canyons124511593c_anyons
caribous1258823caribous
carious93320283c_arious
caseous9312513c_aseous
ceraceous1346353ceraceous
cernuous1055013cernuous
chancrous1644873chancrous
chanoyus1643923chanoyus
chansons1337473chansons
chantors133710263chantors
clangors11417003clangors
clangour11293803clangour
clangours12263123clangours
clanks124615183clank__s
congous103615083c_ongous
corantoes1147653corantoes
corantos10310103coranto_s
corneous10310033corneous
crackers164111723crackers
crackles164111273crackles
crackpots1942833crackpots
cracks144817003crack__s
crackup1743563crack_up
crackups1843123crackups
crakes124921813cra_k_es
cramboes1436543cramboes
crambos1336783crambo_s
crampons1436643crampons
cranches153114543cranches
cranes84330753cran__es
cranium11911103cran_ium
craniums1297913craniums
crank114819613crank___
crankcase1742343crankcase
cranked143812843crank_ed
cranker133612793crank_er
crankest1438143crankest
crankier14339163crankier
crankiest1538823crankiest
crankily1755623crankily
cranking154613073cranking
crankish1736513crankish
crankle133610063crank_le
crankled15408153crankled
crankly16358123crank_ly
crankpin16103753crankpin
crankpins17133763crankpins
cranky153910633crank__y
crannies10313013crannies
crannog1044243cranno_g
crannoge1144263crannoge
crannoges1244243crannoges
crapulous1343963crapulous
cratons94316033cra_tons
crayons12439233cra_yons
cribrous1246013cribrous
crinkles14269163crinkles
croupous1245923croupous
cutaneous1144983cutaneous
frabjous2042633frabjous
frankers15348353frankers
franks134912733frank__s
gracious1138593gracious
grantors93810353grantors
pranks124814723prank__s
rakus94413673_ra_k_us
ramous8417113_ra_mous
rancors9811373_rancors
rancour987133_rancour
rancours1076713_rancours
randoms102112433_randoms
rankers113217463_rankers
rankles113114543_rankles
ranks95225733_rank__s
ransoms92410163_ransoms
raucous938303_raucous
sanious7514103_sanious
stannous846443stannous
tranks104017763trank__s
transoms1048933transoms
trappous1246023trappous
tyrannous1243253tyrannous
urinous7310083urin_ous

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621097.26320124.2
3Display Results1091090.0502180.0
 (SQL Overall)1786911097.73623098.6
 
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.