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

59 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
clypeal144351(None) 
calyceal1543042calyceal
clypeate1543872clypeate
clypei1334162clype_i
clypeus1433242clypeus
cryptal1445682cryptal
allheal1044553allheal
appeal103911613_appeal
blype12429673blype__
blypes13357543blype_s
caliphal1544033caliphal
carpal103716253carp_al
carpel105418473carpe_l
cereal8315833c_ereal
chapeau1435523chapeau
chapel134911373chape_l
choreal124412223choreal
clausal936273clausal
claypan1434313clayp_an
clean75420413cl__ean
clear76219053cl__ear
cleat76335063cl__eat
clepe94617383clepe__
cleped115114113clepe_d
clepes104214623clepe_s
clinal8311553cl_inal
cloacal1135163cloacal
clonal8310913cl_onal
clupeid1234633clupeid
compel124412893compe_l
conceal113313023conceal
congeal104011683congeal
copal95621783c_op_al
corneal94414503corneal
cowpea1337643cowpea_
cowpeas1437273cowpeas
crystal1237433crystal
cuneal8611513c_uneal
cupel9514303c_upe_l
cuspal1037883cusp_al
cymbal15236913c_ymbal
cypsela1442443c_ypsela
ectypal1442773ectyp_al
flyleaf1642583flyleaf
gluteal854243gluteal
hyphal1736423_hyphal
ileal56118083il__eal
keypal1534893keyp_al
lapel73716683_lape_l
leal46043273_l__eal
lineal65616033_lineal
loreal63814313_loreal
luteal64411483_luteal
lycea10418943_lycea_
peal68648103___peal
repeal84718293_repeal
slype105112363slype__
slypes114410483slype_s
typal105311153_typ_al

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.406440125.6
2DLD Change Limit134027596.51320578.4
3Display Results59590.0331787.9
 (SQL Overall)178691596.95225703.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.