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

84 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
explain166704(None) 
explains1766441explains
elain55324702e__lain
exclaim1844942exclaim
exilian1446962exilian
explained1944542explained
explainer1844242explainer
explant16310132explant
exploit1648622exploit
plain74823302__plain
reexplain1852962reexplain
blain75421793__blain
calpain11310413calpain
caplin103216303capl_in
captain112111063captain
chaplain1546193chaplain
complain1448763complain
eclair836813e_clair
elains64919853e__lains
elan46734243e__la_n
elfin84312463e__lfin
eloin55923203e__loin
empaling1338363empaling
emplace1338263emplace
emplacing1645483emplacing
emplane11410013emplane
emplaning1446533emplaning
enchain1248853enchain
engrain838353engrain
enplane939723enplane
enplaning1246803enplaning
entrain7313073entrain
eolian6312593e_olian
euploid1038963euploid
exalting1638033exalting
exclaims1943943exclaims
exclave1945193exclave
exhaling1936293exhaling
exilic1597783exil_ic
exiling15311083exil_ing
expand16236573exp_and
expat14313813exp_a_t
expats1537683exp_ats
expelling1936133expelling
expiate16910593expiate
expiating1938543expiating
expiation18710423expiation
expiring1836253expiring
explainers1943113explainers
explaining2044303explaining
explanting2045223explanting
explants1737023explants
explicit1946463explicit
explode1745963explode
exploding2044933exploding
exploits1745973exploits
explore1646613explore
exploring1945543exploring
explosion18115213explosion
exposing1836673exposing
exposit1649683exposit
expulsing1944283expulsing
expulsion1843893expulsion
exulting1637643exulting
lain46146283___lain
mislain9311243mislain
outlain71212613outlain
pain65647243__p_ain
papain10313793pap_ain
peneplain13113943peneplain
plaid85118303__plaid
plains85019593__plains
plaint85323203__plaint
plait75631573__plait
plan65833943__pla_n
poplin10413483popl_in
reexplains1952773reexplains
replan83215823repla_n
sextain14257103sex_tain
slain54923573__slain
sprain83614863_sprain
unplait948603unplait
villain1038473villain
xylan1537463_xyla_n

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 Filter1786911340270.423422437.4
2DLD Change Limit134027846.79619721.5
3Display Results84840.0332545.5
 (SQL Overall)178691847.25224640.2
 
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.