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

159 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
knawels1434468(None) 
knawel13415411knawel_
knawes13328391knawe_s
enamels9128162enamels
gnawers11356392gnawers
knaves13439522knave_s
knawe12397882knawe__
kneels10408932kn_eels
knowers1436342knowers
navels95712692_navels
newels93710822_newels
anadems1036143anadems
angels74416173an_gels
answers1037043answers
awes76037553__awe_s
awls75926093__aw_ls
awols84713523__awols
axels126313633__axels
babels105216723_babels
bagels95712313_bagels
bawls105719323_baw_ls
boatels93510233boatels
bowels114315593_bowels
brawls115214333braw_ls
camels105217083_camels
cancels114113313cancels
cannels93413363cannels
chapels14429153chapels
chawers154412053chawers
clawers123910973clawers
crawls114712083craw_ls
crewels12438483crewels
dowels104813343_dowels
drawees11378363drawees
drawers113610073drawers
drawls105511393draw_ls
easels65914553_easels
enables92813123enables
enamel81210113enamel_
enates64026423enate_s
gavels105911093_gavels
gnarls74210773gna_rls
gnawed11427833gnawe_d
gnawer10386953gnawe_r
gnaws96311143gnaw__s
gravels113611143gravels
hansels104011653hansels
hazels185710083_hazels
inanely1037943inanely
inanes62519803inane_s
indwell1143903indwell
indwells1243693indwells
indwelt1146513indwelt
inkwell1442533inkwell
inkwells1542563inkwells
inwalls1037283inwalls
jewels16508613_jewels
kaes85734063k_a_e_s
kails95525213k_a_ils
kales95730983k_ale_s
kames115024693k_ame_s
kanes95529373k_ane_s
kantele1138253kantele
kanteles1238123kanteles
kayles134712003k_ayles
keels94622413k__eels
kennels11387193kennels
kernels11417953kernels
kevels134410713k_evels
khazens2332663khazens
kinases113511123kinase_s
knackers13286843knackers
knacks11428543kna_cks
knappers16315643knappers
knaps115511173kna__ps
knapweed1842443knapweed
knapweeds1941573knapweeds
knars94416113kna__rs
knaurs10466963kna_urs
knave12389463knave__
knavery1733123knavery
kneaders1384713kneaders
kneel95012033kn_eel_
knees95114873kn__ees
knell94210923kn__ell
knells10439253kn_ells
knelt94617683kn__elt
knifers14537083knifers
knifes136210213knife_s
knives13458553knive_s
knolls10367413kn_olls
knower1337073knowe_r
knowns13426443know_ns
knows124912413know__s
knurls10396243kn_urls
koels94613903k__oels
kraals10378433kra_als
krakens1034293krakens
kraters114212343kraters
krewes1337923krewe_s
kugels1146073k_ugels
kummels15234793kummels
kvases13467103kvase_s
labels84515683_labels
lapels83712043_lapels
mangels103614493mangels
mantels94515043mantels
nabes75427093_nabe_s
nails55730403_na_ils
naleds7469133_naleds
namely113711323_namely
namers84517333_namers
names74833363_name_s
napes74828463_nape_s
nares55544153_nare_s
narwals1036983_narwals
nasals63312463_nasals
nates55238333_nate_s
navel87016573_navel_
naves87030383_nave_s
nawabs1185063_nawabs
newel86114133_newel_
noels56418703_n_oels
novels95512503_novels
onagers838103onagers
panels84716523_panels
pawers114818783_pawers
pawls105617663_paw_ls
ratels64518213_ratels
ravels94717073_ravels
rowels94515453_rowels
sawers94620163_sawers
shawls125411973shaw_ls
snails64816653sna_ils
snakes103919603snake_s
snarers74216663snarers
snares65329033snare_s
snarls64016873sna_rls
snawed104813733snawe_d
snaws86116363snaw__s
snivels10336903snivels
taels56822073_ta_els
tawers94118603_tawers
teasels74311313teasels
teazels16406883teazels
thawers13428483thawers
towels94314643_towels
tramels93812493tramels
travels104711293travels
trawls94412393traw_ls
trowels10358363trowels
unawed103914903unawe_d
unravels1144633unravels
unreels7258313unreels
unwell9349443un_well
vowels124410483_vowels
wawls115416473_waw_ls
weasels10468503weasels
yawls114613603_yaw_ls

Search took 7 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.1531167915.0
2DLD Change Limit1340271596.31321230.3
3Display Results1591590.0632523.8
 (SQL Overall)1786911596.52927368.8
 
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.