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

71 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
ectopia114769(None) 
ectopias1248271ectopias
ectopic1338151ectopic
cecropia1455152cecropia
ectozoa1843142ectozoa
entopic1149952entopic
octopi1036532octopi_
scotopia1245732scotopia
utopia8107882_utopia
acholia1239973acholia
acromia1139963acromia
actinia91710853actinia
anopia83412393_anopia
atonia63816513_atonia
atopic103514143_atopic
cecropias1545113cecropias
celosia939463celosia
chopin132712193_chopin
cobia94117513_c_obia
copra98115463_c_opra
coria75828323_c_oria
dystopia1444833dystopia
ecbolic1345623ecbolic
echoic1339043echo_ic
ecotypic1744413ecotypic
ectasis9249613ectasis
ectatic11310123ectatic
ecthyma1752613ecthyma
ectoplasm1544613ectoplasm
ectozoan1943393ectozoan
ectypal1442773ectypal
ectype1334283ectyp_e
ectypes1434803ectypes
emporia1148753emporia
encomia1147983encomia
entasia73110063entasia
entia5318203ent__ia
entoil6912493ento_il
entozoa1644233entozoa
entropic1249683entropic
esotropia1185563esotropia
estop74312103estop__
estops84011223estop_s
eulogia846663eulogia
exotropia18145253exotropia
meropia1149613meropia
metopic1339763metopic
myopia13318443_myopia
octopod1244893octopod
octopus1144813octopus
photopia1549733photopia
rectorial11119893rectorial
scholia1237833scholia
scoria8513503sc_oria
scotia8310803sc_otia
scotopias1345693scotopias
scotopic1446513scotopic
sectorial111110013sectorial
senopia949233senopia
sinopia947743sinopia
subtopia1245403subtopia
tectonic1248453tectonic
tectorial11119033tectorial
tentoria8119263tentoria
topi67830393__topi_
topic95721503__topic
topis76025833__topis
utopian9126273_utopian
utopias9117723_utopias
vectorial14147403vectorial
victoria1346313victoria

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.406440125.6
2DLD Change Limit134027717.36018210.2
3Display Results71710.0302366.7
 (SQL Overall)178691717.79622920.9
 
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.