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 “deltaic” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
deltaic103702(None) 
deltic9312501delt_ic
delphic1545102delphic
delta66117772delta__
deltas74414822delta_s
deltoid938572deltoid
destain8412082destain
detail74516432de_tail
detain74617382de_tain
voltaic1245452voltaic
alcaic1039983_alcaic
benthic1437473benthic
celiac101910433celia_c
centai84814783centai_
centric11312403centric
certain92612213certain
cultic105111903cult_ic
dalmatic1348693dalmatic
daltonic1146523daltonic
deair65817193de__air
declaim1247363declaim
deictic1237703deictic
deific1237313de_ific
deistic10311173deistic
delaine8314793del_aine
delate73827753del_ate
delated93722873delated
delates83526283delates
delating103119603delating
delation92318083delation
delator83015033delator
delay94820633del_a_y
delays104014053del_ays
delead84112343delea_d
deleads9379703deleads
deleave1147723deleave
deli55631293del__i_
delict94320333del__ict
delimit10311733delimit
deliria868313deliria
delis64928543del__is
delt57855273delt___
deltoids1045483deltoids
delts65731793delt__s
demic105119193de__mic
demonic12311223demonic
demotic12412353demotic
dental74319173denta_l
dentalia947533dentalia
dentals83915393dentals
dentate8315153dentate
dentil74017883dent_il
dentin73919573dent_in
dentoid9310663dentoid
deontic1038883deontic
derail74218813de_rail
dermic114511913de_rmic
despair1045463despair
destains9311813destains
detach12310413de_tach
details84214043de_tails
detains83716093de_tains
detick1339383de_t_ick
detrain8412253detrain
deuteric1146353deuteric
deutzia1743143deutzia
dextrin1587543dextrin
distain8313783distain
ectatic11310123_ectatic
elain55324703_el_ain
enatic8317563_enatic
entail61114343_entail
ethic101511223_e_thic
etic66123953_e_t_ic
felsic1147053fel_sic
gelati73814533gelati_
gelatin83514733gelatin
gelatis83313513gelatis
gestic9312773gest_ic
hectic132311523hect_ic
heliac111010893helia_c
hematic141816753hematic
hepatic141712773hepatic
identic1038043ident_ic
laic65931563__l_aic
lentic83515743lent_ic
melanic11310403melanic
melic94722333mel__ic
melodic1238543melodic
meltage1037953meltage
metric10314683me_tric
nematic111714003nematic
pectic122913873pect_ic
pelagic1237863pelagic
pelitic111814653pelitic
peloric11310713peloric
peltast9310513peltast
peltate92013773peltate
pelvic13307553pel_vic
peptic122113153pept_ic
pertain92714963pertain
prelatic12311293prelatic
redtail858713redtail
relaid75518443rel_aid
relic74623363rel__ic
retail65522073re_tail
retain64523283re_tain
selenic9410663selenic
sematic111716883sematic
septic102713193sept_ic
sextain14257103sextain
sultanic1046173sultanic
telic76019823tel__ic
telomic1147603telomic
tetanic9810133te_tanic
venatic12311523venatic
ventail10310453ventail
zebraic2044293zebraic

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 Limit1340271186.75019855.9
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.20224811.3
 
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.