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

133 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
frostless123574(None) 
frontless1235401frontless
costless10310002_costless
crestless1146782crestless
crustless1155392crustless
feastless1235042feastless
footless113710802f_ootless
fretless1138062fr_etless
frockless1843452frockless
frontlets1244232frontlets
frosteds12305652frost_eds
frostiest1239212frostiest
frostiness1336562frostiness
fruitless1244162fruitless
restless82713162_restless
rootless83910442_rootless
rustless83510232_rustless
trustless955932trustless
apostles1037753apostle_s
artless73712513ar__tless
blotless10347143blo_tless
boltless10338283_boltless
bootless103410983_bootless
bractless1335543bractless
bristles101510433bristle_s
broodless1235033broodless
browless1346653bro_wless
brushless1444003brushless
coatless1039693_coatless
cropless1237793cro_pless
crosslets1145183crosslets
crossness1137093crossness
crownless1443423crownless
dustless9328343_dustless
effortless1641483effortless
fastness11238763f_astness
fatless103212203f__atless
faultless1243163faultless
feetless1137383f_eetless
firstness1245003firstness
fishless1436413f_ishless
fleshless1543993fleshless
flockless1843163flockless
floorless1243793floorless
flourless1243533flourless
foamless13195843f_oamless
fogless1138193f_o_gless
foodless12338383f_oodless
footlers113910793f_ootlers
footles103715713f_ootle_s
forceless1435723forceless
fordless12289003f_ordless
forkless15267433f_orkless
formless13248083f_ormless
fortress1136753f_ortress
fosters104220093f_ost_ers
frameless1435533frameless
freshness1545943freshness
froglets1235263fro_glets
frontes104214163front_e_s
frontiers1254993frontiers
frontlet1147653frontle_t
frontlist1246123frontlist
frontlists1344513frontlists
frosted113211873frost_e_d
frostfish1842623frostfish
frostier1148163frostie_r
frostings1335733frostings
frostline1245873frostline
frostlines1345183frostlines
frostnips1441933frostnips
frosts94214623frost___s
frothers14279803fro_thers
frowstiest1643083frowstiest
fruitlets1243173fruitlets
frustules1244653frustule_s
fuseless11237233f_useless
grassless1034303grassless
gristles9189203gristle_s
grossness1045963grossness
groveless13235363groveless
gustless9287683_gustless
horseless1237213horseless
hostess103210233_host_ess
hostlers113310483_hostlers
jostlers15357683_jostlers
jostles143411143_jostle_s
knotless1264563kno_tless
listless8269263_listless
loftless1135903_loftless
lossless835473_lossless
lostness837683_lostness
mastless102610023_mastless
noseless839513_noseless
ostlers72911203__ostlers
pastless102411203_pastless
plotless10256793plo_tless
poetless1038723_poetless
portless10310643_portless
prestress1138133prestress
printless1137513printless
profitless1542763profitless
prosiness11311673prosiness
prostheses1546533prostheses
prosthesis1546133prosthesis
prosties101421193prostie_s
prostyles14157113prostyle_s
restress82511773_restress
riftless1136943_riftless
riskless1235763_riskless
roadless937693_roadless
rockless14297293_rockless
rodless8310073_ro_dless
roofless11316733_roofless
rootles73215633_rootle_s
rootlets8308653_rootlets
rosiness82613173_rosiness
rosters73727533_rost_ers
rustlers8339853_rustlers
rustles73416413_rustle_s
spotless1037043spo_tless
spoutless1134243spoutless
throstles1265883throstle_s
trestles83012553trestle_s
urostyles12173973urostyle_s
vestless11258843_vestless
waistless1235093waistless
wrastles11328933wrastle_s
wrestlers12306103wrestlers
wrestles113310063wrestle_s
wristlets1244473wristlets
yeastless1234053yeastless
zestless17247433_zestless

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.1731032896.0
2DLD Change Limit1486411337.09320956.0
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.32924381.4
 
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.