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

107 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
gothics133612(None) 
gothic1237791gothic_
bothies12414782bothies
ethics11169282_ethics
gothicism1743792gothicism
gothite1146402gothite
gothites1246012gothites
goths96513002goth__s
antics84621453ant_ics
atomics113110853atomics
atonics93613713atonics
attics84413283_attics
bioethics1643843bioethics
biotics113812173biot_ics
bothers124317753bothers
chics123920943__chics
cochins141413103cochins
colics104219903co_lics
comics124015563co_mics
conics103920593co_nics
erotics91914153erot_ics
ethic101511223_ethic_
ethnics1236263_ethnics
exotics16229193exot_ics
garlics1038013garlics
gathers114315073gathers
georgics1242873georgics
ghis85020163g__hi_s
glochids1543953glochids
glottic1036653glottic_
glottis837173glotti_s
gnathic1344843gnathic_
gnostics1146323gnostics
goalies8316023goalies
gobies95418063go_bies
goblins1039243goblins
godships1544723godships
godwits1234133godwits
goethite1244053goethite
goethites1344253goethites
gonifs104310133go_nifs
goodies93516993goodies
goonies83618333goonies
gophers1338983gophers
gorhens1137183gorhens
gossips1035903gossips
gotchas1334613gotchas
goth86825083goth___
gothicisms1853393gothicisms
gothicize2443623gothicize
gothicizes2543383gothicizes
graphics1645653graphics
hotties103016963hotties
ionics84214483io_nics
lathis95516173lathi_s
lithias1038823lithias
lithic1139493lithic_
logics95711123lo_gics
lotic76420673lot_ic_
metrics11312363metrics
miotics112710653miot_ics
mosaics1138073mosaics
mothers123717623mothers
mothier121910213mothier
mothiest13311033mothiest
moths106021553moth__s
motifs1139673mot_ifs
myotics14257603myot_ics
mythic1637273mythic_
nothing113511903nothing
nothings12266683nothings
notice8313443not_ice
notices9312283not_ices
ohias84415573_o_hias
ootheca1244003ootheca
ootids71110353oot_ids
optics102810183_optics
osmics1036463_osmics
others93918003_others
otic66624823_ot_ic_
outhits102213503outhits
photics142810483phot_ics
poetics11312073poetics
pothers123818623pothers
pothos114214693poth_os
potpies113116173potpies
potsies93019483potsies
potties93723543potties
roshis9311793roshi_s
rotis56327063rot_i_s
sonics84315633so_nics
sophies12314613sophies
soths86218633soth__s
stoics8311113_stoics
thick145613353__thick
thicks154511993__thicks
thins85826333__thins
this76027383__thi_s
tics65729633__t_ics
tonics83617863to_nics
topics104714583to_pics
torics85118353to_rics
toxics153910203to_xics
vitrics12198553vitrics
withies133913543withies
withins133511693withins
worthies14310283worthies

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.1561145455.1
2DLD Change Limit1340271076.75019855.9
3Display Results1071070.0303566.7
 (SQL Overall)1786911076.93625762.8
 
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.