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

90 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
allelic9118171allelic
alleged9389322alleged
allele64514562allel_e
alleles73812032alleles
allelism1046972allelism
alleluia843382alleluia
allylic12155842allylic
annelid838732annelid
abelia83114403a_belia
abled86926833able__d
afield1035953afiel_d
ailed66240283aile__d
albeit8314343albe_it
alcid85817973a_l_cid
alevin92511513a_levin
alexia132910463a_lexia
alexin132311483a_lexin
algid75415583a_l_gid
algoid83011473a_lgoid
aliened81011743aliened
alkali10127563alkali_
alkalic13146973alkalic
alkalin11178183alkalin
alkalis11148793alkalis
alkaloid1345293alkaloid
alkylic16174233alkylic
allayed11138063allayed
allee54932123alle__e
allees64521483alle_es
allege74314653alle_ge
alleger8319633alleger
alleges84212573alleges
alleging1038473alleging
allegro844853allegro
allelisms1156003allelisms
alleluias943623alleluias
allergic11125383allergic
allergin9136303allergin
allergy1144503allergy
alley85721673alle__y
alleys95113303alle_ys
allicin949953allicin
allied74217153all_ied
allod64418383a_l_lod
allodia8128793allodia
allowed111610083allowed
alloyed11158033alloyed
allseed835953allseed
alluded9327093alluded
allured8299173allured
alluvia1045193alluvia
allyl85310543allyl__
allyls9437273allyl_s
aloetic9313183aloetic
altered83215753altered
alveoli1043583alveoli_
aneled74719283a_neled
angeled93211513angeled
angelic1039623angelic
annelids946233annelids
aphelia1249423aphelia
atelic8313703a_telic
axled135315813axle__d
balled94926893balle__d
balletic1248073balletic
called94126733calle__d
camelid1249413camelid
clerid9312413_clerid
eyelid1038443_eyelid
felid94717173__felid
galled84622863galle__d
gallein8299043galle_in
galleria946493galleria
galleried1146933galleried
galleted1038223galleted
gelid74916983__gelid
hallel93514093hallel__
hallels103310133hallel_s
labeled102510563labeled
lalled74218753lal_led
lapeled10258893lapeled
malled94626113malle__d
mallei84414633malle_i_
malleoli1054053malleoli_
palled94625163palle__d
palleted1139873palleted
pallid93915283pal_lid
valleyed1534013valleyed
walled104021293walle__d
walleyed1534153walleyed

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 Filter1786911340270.390458182.1
2DLD Change Limit134027906.15621771.8
3Display Results90900.0303000.0
 (SQL Overall)178691906.57627173.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.