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

150 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
scandic123700(None) 
scaldic1235941scaldic
scandia1038061scandia
candid104517852_candid
cantic103920542_cantic
scandal1038672scandal
scandias1137862scandias
scandium1365692scandium
scenic10510512scen_ic
skaldic1443552skaldic
stannic936662stannic
syndic1237302s_yndic
acidic113612133ac_idic
acinic104713543acin_ic
anodic92813133__anodic
antic75728863__antic
asdic83814093__asdic
bandit93821133_bandit
bardic11312923_bardic
caddice13327733_caddice
caddie104316453_caddie
caddis104613383_caddis
cadi75732183_ca_di_
cadis84428503_ca_dis
cadmic1338983_cadmic
calcic9311873_calcic
candida114110253_candida
candids113812693_candids
candied113816023_candied
candies104125613_candies
candle94321483_candle
candor94516423_candor
candy115119823_cand_y
canid85526343_can_id
canids95118133_canids
cannie83819363_cannie
canonic11312933_canonic
canopic1338803_canopic
capric12411803_capric
cardia9916383_cardia
cardiac1278823_cardiac
cardio9915673_cardio
caseic103212373_caseic
conic95329793_con_ic
cyanic133110773cyan_ic
cynic124712423_cyn_ic
dyadic1336093dya_dic
fanfic1436313_fanfic
frantic12310373frantic
fundic12389083_fundic
gonadic1177213gonadic
iconic10411593icon_ic
manic94629443_man_ic
mantic104120903_mantic
monadic1268883monadic
nandin7313033_nandin
oceanic1146163ocean_ic
octadic1245713octadic
pandit93820753_pandit
panic93923903_pan_ic
pianic103714123pian_ic
quantic18279063quantic
saccadic1244173saccadic
sadi55834643s_a_di_
sadis64930853s_a_dis
salic73424713s_a_lic
sand55338473s_and__
sandal73317283s_andal
sanded84920613s_anded
sander74828533s_ander
sandhi1038193s_andhi
sandhis1139993s_andhis
sandier84017843s_andier
sanding93520603s_anding
sandpit1049633s_andpit
sands65228583s_and_s
sandwich1743653s_andwich
sandy94221133s_and_y
santir6315253s_antir
satanic939933satan_ic
scad75725773sca_d__
scads85419963sca_d_s
scald84818123scald__
scalded11409763scalded
scalding12339393scalding
scalds94813693scald_s
scampi12469103scampi_
scan65530453scan___
scandals1136993scandals
scandent1148493scandent
scandiums1443983scandiums
scanned104110893scanned
scanner94411813scanner
scanning113310773scanning
scans74625103scan__s
scansion1045693scansion
scant79735073scan__t
scanted104114393scanted
scanter94215183scanter
scantier10309983scantier
scanties103215423scanties
scantily1337583scantily
scanting113914763scanting
scantly12419553scantly
scants85219723scan_ts
scanty114014663scan_ty
scend85516293scend__
scended11329873scended
scending122610583scending
scends95213003scend_s
scenics1137773scen_ics
sceptic1337833sceptic
sciatic11910173sciatic
scudi85112163sc_udi_
secondi1044943secondi_
semantic1249553semantic
shandies122714113shandies
shandy134710033shand_y
shanti94014093shanti_
shantih13309643shantih
shantis103313103shantis
shindig12244243shindig
sialic8313633sia_lic
slander84015443slander
sodic84917493s__odic
sonantic1048273sonantic
sonic75225293s_on_ic
spadix1636113spa_dix
spandex1735833spandex
spandril1144093spandril
spastic11310383spastic
spathic1437543spathic
spondaic1343013spondaic
stadia7312143sta_dia
stand65923283stand__
standby1334423standby
standee83514513standee
stander84316163stander
standing103413633standing
standish1238543standish
stands75118053stand_s
standup1034353standup
stanzaic1943363stanzaic
static83118683sta_tic
syndics1335703s_yndics
synodic1347363synodic
tannic82811473_tannic
uncandid1244603uncandid
uranic82315183uran_ic
vanadic1336743_vanadic

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.403443402.0
2DLD Change Limit1340271506.08022043.9
3Display Results1501500.0632381.0
 (SQL Overall)1786911506.54627297.7
 
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.