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

55 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
ethnically184783(None) 
ethically1748711eth_ically
ethnical1346362ethnica_l_
technically2146442technically
tetanically1648062tetanically
tonically14311142_tonically
actinically1847083actinically
atomically1749873atomically
atypically2045743atypically
axenically2246803axenically
botanically1847013botanically
clinically1747073clinically
conically16312813_conically
cynically1947253_cynically
demonically1947843demonically
ectopically2047123ectopically
emetically17411423emetically
epically15310583e__pically
erotically15414313erotically
ethereally1653543ethereally
ethical1238443eth_ica_l_
ethicality1853833eth_icality
ethicals1345533eth_ica_ls
ethnicity1744593ethnic_ity
eugenically1745843eugenically
euphonically2254603euphonically
exotically2249493exotically
finically1747953_finically
genically151110173_genically
gothically1946713goth_ically
hedonically2046883hedonically
iconically1769273iconically
irenically15710313irenically
ironically151110543ironically
manically16311703_manically
mechanically2455593mechanically
methodically2356153methodically
metrically17411083met_rically
mythically2345843myth_ically
ohmically1946903_ohmically
panically16310433_panically
phonically2049023phonically
satanically1647083satanically
scenically1747943scenically
sonically14310953_sonically
statically15411573statically
sterically15410493sterically
stoically1449673st_oically
tectonically1946323tectonically
telically1449853_telically
thetically18410493_thetically
titanically1646573titanically
topically1649533_topically
toxically2147573_toxically
typically1946083_typically

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 Filter1786911406030.420425454.8
2DLD Change Limit140603555.53325411.7
3Display Results55550.0301833.3
 (SQL Overall)178691555.98329866.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.