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

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

61 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
photoelectronic2472541photoelectronic_
photoelectric2263833photoelectr__ic_
photoelectron2063783photoelectron___
photoelectrons2173373photoelectron__s
optoelectronic2071874_optoelectronic_
optoelectronics2171514_optoelectronics
electronica1586445_____electronica
isoelectronic1762185__isoelectronic_
microelectronic20112535microelectronic_
nonelectronic1762755_no_nelectronic_
electronic1477946_____electronic_
electronicas1675536_____electronicas
electronics1557216_____electronics
interelectronic19132016interelectronic_
photochromic2664496photo___chromic_
photomechanical2971896photo_mec_hanical
photometric2058606photo_me_tr__ic_
phototropic2058206photo____tropic_
piezoelectric2871836piezoelectr__ic_
pyroelectric2163096p_yroelectr__ic_
antielectron1463457_antielectron___
antielectrons1562987_antielectron__s
bioelectric1753287__bioelectr__ic_
bioelectrical1962257__bioelectr__ical
ferroelectric2072027ferroelectr__ic_
ferroelectrics2171657ferroelectr__ics
geotectonic1652127geot___ect_onic_
hydroelectric2462397hydroelectr__ic_
isoelectric1553017__isoelectr__ic_
myoelectric2062837__myoelectr__ic_
myoelectrical2261747__myoelectr__ical
nonelectric1555187_no_nelectr__ic_
nonelectrical1763487_no_nelectr__ical
photochromism2763667photo___chromism
photodetector2192407photodetect_o___r
photodetectors22102257photodetect_o__rs
photogenic1848297photo_ge____nic_
photogeologic2263737photo_ge_ologic_
photogeological2463107photo_ge_ological
photolytic2047727photo_l_yt___ic_
photometries1968337photo_me_tr__ies
photoperiodic2362907photo_pe_riodic_
photoreaction20134177photoreaction___
photoreactions21113567photoreaction__s
photoreception2373787photoreception___
photoreceptions2473357photoreception__s
photoreduction2283717photoreduction___
photoreductions23153347photoreduction__s
phototactic2055297photo_tact___ic_
phototoxic2456667photo____t_oxic_
phototropism2156327photo____tropism
phytoplanktonic3181407phytoplanktonic_
polyelectrolyte25121287p_olyelectrolyte
postelection1654557p_ostelection___
preelectric1753517p__reelectr__ic_
protectionism1984947prot___ectionism
protectionist17116687prot___ectionist
pyroelectricity2771497p_yroelectricity
thermoelectric23102477thermoelectr__ic_
triboelectric1971777triboelectr__ic_
turboelectric1971897turboelectr__ic_

Search took 10 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 Filter178691950240.390458182.1
2DLD Change Limit95024618.55011113.9
3Display Results61610.0461326.1
 (SQL Overall)178691618.98619885.5
 
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.