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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
crownless144342(None) 
browless1346652brow_less
brownness1444342brownness
crewless1335412crew_less
cropless1237792cro_pless
crowners133710752crown_ers
crownets13407672crown_ets
downless1236362_downless
townless1135652_townless
arrowless1242813arrow_less
awnless1035923__awnless
boonless10328353_boonless
bowless123310313_bow_less
brainless1136403brainless
broodless1235033broodless
brownest1398893brown_est
brownies13189613brownie_s
browniest14207123browniest
carbonless1444083carbonless
chinless1337493c_hinless
clawless1334123claw_less
cloudless1243153cloudless
coalless1038193c_oalless
coatless1039693c_oatless
codeless112010113c_odeless
confess12399903c_o_nfess
cookless14258633c_ookless
coolness1037743cooln_ess
cordless11299963c_ordless
coreless103013833c_oreless
costless10310003c_ostless
countess103710053c_ountess
countless1146373c_ountless
coxless1637743c_o_xless
coyness1277323c_oyn_ess
crawlers13309013craw_lers
crestless1146783crestless
crimeless1335063crimeless
crones84729243cro_n_e_s
cronies9622503cro_nie_s
crooners103911393croon_ers
crosslets1145183crosslets
crossness1137093crossness
crowders14398813crow_ders
crowdies1437553crowdie_s
crowers124614903crow__ers
crowned133912433crown_e_d
crowner124012603crown_e_r
crownet123714113crown_e_t
crowns115615113crown___s
crowsteps1642533crowsteps
cruelness1145053cruelness
crustless1155403crustless
drollness1043623drollness
drowners12428273drown_ers
frockless1843453frockless
frontless1235403frontless
frostless1235743frostless
frowners14377933frown_ers
grainless1035893grainless
groundless1243473groundless
groveless13235363groveless
growlers12327093grow_lers
hornless1137363_hornless
ironness836953iro_nness
lowness1037813_lown_ess
moonless10278043_moonless
nounless837253_nounless
nowness1037033_nown_ess
prowess1237903prow__ess
prowlers13328933prow_lers
rainless8129703_rainless
rawness1038153_rawn_ess
reinless8139433_reinless
roadless937703_roadless
rockless14297293_rockless
rodless8310073_ro_dless
roofless11316733_roofless
rootless83910443_rootless
runless72810423_r_unless
slowness1135013slown_ess
snowless1145633snow_less
sonless72612613_so_nless
thornless1243633thornless
thowless1434613thow_less
townlets1134773_townlets
trowelers12105263trowelers
vowless13246603_vow_less

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 Filter1786911486410.406440125.6
2DLD Change Limit148641887.32620289.5
3Display Results88880.0461913.0
 (SQL Overall)178691887.77822973.9
 
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.