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

81 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
deictics134556(None) 
deictic1237701deictic_
deistic10311172deistic_
deities82621922dei_ties
demotics1338752demotics
arctics1138953_arctics
biotics113812173_biotics
cecities12312043cecities
clitics11279973cli_tics
critics112811093cri_tics
dainties9312403dainties
deceits102810883de_ceits
decries103319803de_cries
deficits1447273defic_its
deicers103612733deic_ers
deices94119373deic__es
deicide1149403deic_ide
deicides1249303deicides
deicing11312193deic_ing
deific1237313dei_fic_
deifies113317453dei_fies
deistical1246673deistical
deists74916433deist__s
deixis1437243dei_xi_s
delicts104012253delict__s
deltic9312503de_ltic_
demotic12412353demotic_
dentils84115583de_ntils
dentins83419223de_ntins
deontic1038883deontic_
depicters1435823depicters
depicting1537813depicting
depiction1437273depiction
depictions1546893depictions
depictors1465943depictors
depicts12358463depict__s
deputies1157533deputies
descries11311923descries
detick1339383de__tick
deticks1437353de__ticks
dickies143416343d_ickies
dictier103411863d_ictier
dictiest113212783d_ictiest
diction102313053d_iction
dictions111812673d_ictions
dictums1235553d_ictums
didactics1543493didactics
dietetics1244693dietetics
dirties83119383d_irties
distich13312173d_istich
distichs1447633d_istichs
distils83015803d_istils
ditties83116983d_itties
edicts94911703edict__s
ekistics1485703ekistics
emetics11610723_emetics
eristics10610193eristics
erotics91914153_erotics
exotics16229193_exotics
genetics11128613genetics
hectic132311523he_ctic_
hematics151712193hematics
hepatics15198933hepatics
heretics13310503heretics
ictic9311803__ictic_
lectins92515003le_ctins
meiotic11410933meiotic_
memetics1447803memetics
miotics112710653_miotics
pectic122913873pe_ctic_
pectins112315233pe_ctins
peptics132610243pe_ptics
picnics13297343_picnics
quintics19266983quintics
sciatics12117273sciatics
semiotics1376913semiotics
septics112810433se_ptics
tactics1149323_tactics
tictacs1145793_tictacs
tictocs1145903_tictocs
victims1436003_victims

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit146162817.65619091.2
3Display Results81810.0302700.0
 (SQL Overall)178691818.10922036.1
 
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.