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

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

119 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
panels8471652(None) 
panel76023621panel_
panes76148691pane_s
anele55628832_anele
aneles64626292_aneles
anes45255932_ane_s
angels74416172_angels
anils56326722_anils
apneas83211382apneas
appels104312792appels
axels126313632_axels
babels105216722babels
bagels95712312bagels
banes74945582bane_s
camels105217082camels
canals84421662canals
cancels114113312cancels
caners84629202caners
canes75350372cane_s
cannels93413362cannels
darnels83710432darnels
dynels10536812dynels
easels65914552easels
empanels1244822empanels
fanes84639892fane_s
ganefs10489202ganefs
ganevs10456912ganevs
gavels105911092gavels
hansels104011652hansels
hazels185710082hazels
impanels1245232impanels
janes124928122jane_s
kanes95529372kane_s
labels84515682labels
lanely93914482lanely
lanes54946792lane_s
lapels83712042lapels
manes76648952mane_s
mangels103614492mangels
mantels94515042mantels
navels95712692navels
pacers105124542pacers
paces96741112pace_s
padles95221122padles
pagers94423252pagers
pages85235072page_s
pails75833062pa_ils
palely11311922palely
pales75753802pale_s
palets85122312palets
palls74332562pa_lls
pals66951352pa__ls
pandas95521962pandas
panders103423732panders
pane64950282pane__
paned85437182pane_d
paneled10612572paneled
paneless102611762paneless
panelist10414502panelist
panfuls1237172panfuls
pangas99921102pangas
pangens103112062pangens
pangs84628662pan_gs
panics103815362panics
paniers94717332paniers
panners93621272panners
pannes85522852pannes
pans65855722pan__s
pantos85222742pantos
pants76536922pan_ts
panzers184012012panzers
papers105125322papers
parcels113712662parcels
pareos87023772pareos
parers85530742parers
pares77164482pare_s
pareus85420742pareus
parles86334402parles
parols84722612parols
parrels94713492parrels
paseos88015812paseos
pases75346502pase_s
passels93913022passels
pastels95215182pastels
patens84820862patens
paters84935832paters
pates76047892pate_s
patness92912282patness
pavers115021822pavers
paves104833922pave_s
pawers114818782pawers
pawls105617662pa_wls
pawnees12298172pawnees
pawners124311072pawners
paxes144928422paxe_s
payees114812902payees
payers114621822payers
peels75226422p_eels
pencels113610052pencels
penes75839222pene_s
pineals93212842pineals
pines76048862pine_s
pixels15478532pixels
planers94517942planers
planes85028082plane_s
planets93914082planets
pones74547042pone_s
ranees64623962ranees
ratels64518212ratels
ravels94717072ravels
repanels1036782repanels
sanely93114612sanely
sanes55649072sane_s
spancels1245272spancels
spaniels1045962spaniels
spinels94512442spinels
taels56822072ta_els
vanes85130972vane_s
wanes85040882wane_s

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 Filter178691825510.1261418182.5
2DLD Change Limit825511195.98313797.6
3Display Results1191190.0961239.6
 (SQL Overall)1786911196.20528797.9
 
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.