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

56 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
explorers184374(None) 
exploders1944171exploders
explorer1744711explorer_
explores1746251explore_s
deplorers1245462deplorers
employers1644122employers
expirers1735122exp_irers
exploder1844842exploder_
explodes1845802explode_s
exploiters1943832exploiters
explore1646612explore__
explored1845082explore_d
exporters1846252exp_orters
exposers1736132exp_osers
implorers13124412implorers
colorers10312183_colorers
deplorer1136343deplorer_
deplores1139533deplore_s
deployers1545063deployers
elopers95112943e__lopers
employees1653393employees
employer1564713employer_
employes1555943employe_s
empowers15276843emp_owers
enclosers11105803enclosers
exalters1536653exal_ters
excluders1942713excluders
exhorters1944713ex_horters
exilers14419733exil__ers
expanders19125093expanders
expecters2045473expecters
expellers18104743expellers
expenders19145963expenders
expirer1635993exp_irer_
expires1638683exp_ire_s
explainers1943113explainers
explode1745963explode__
exploded1944753explode_d
exploiter1844583exploiter_
exploits1745973explo_its
exploring1945543exploring
exporter1737363exp_orter_
exports1647983exp_or_ts
exposer1637413exp_oser_
exposes1639963exp_ose_s
express1637493exp__ress
expungers1942693expungers
extollers1663843extollers
extorters1645763ex_torters
implorer12125103implorer_
implores12127043implore_s
plovers123611833__plovers
plowers123812243__plowers
reexplores1952853reexplore_s
splores91910953_splore_s
vaporers1336243vap_orers

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.423422437.4
2DLD Change Limit148641566.93621430.4
3Display Results56560.0331697.0
 (SQL Overall)178691567.39224173.6
 
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.