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

84 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
sigmoid114611(None) 
sigmoids1244451sigmoids
pygmoid1644532pygmoid
sialoid8310962sialoid
siganid947202siganid
sigloi737742sigloi_
sigmoidal1352652sigmoidal
simioid1047992simioid
algoid83011473alg_oid
cirsoid1038123cirsoid
cissoid1037343cissoid
cormoid12310403cormoid
cymoid1459473_cymoid
dermoid1138523dermoid
desmoid1137103desmoid
diamond1186113diamond
diploid11310293diploid
discoid11311243discoid
ethmoid1345803ethmoid
fibroid1337243fibroid
geoid74215763__geoid
haemoid1337203haemoid
hemoid12313513_hemoid
histoid1139823histoid
imid76122293_i_m_id
isthmoid1463093isthmoid
lianoid837533lianoid
ligroin848043ligroin
liguloid1044133liguloid
limpid11389753li_mpid
lipoid9411043li_poid
lithoid1148773lithoid
negroid9108893negroid
oidioid946053oidioid
prismoid1344983prismoid
rigid7913893rig__id
salmonid1147633salmonid
sarcoid10310453sarcoid
scincoid1344753scincoid
sciuroid1144403sciuroid
sesamoid1144063sesamoid
shamois123210423shamois
sialid7314943si_alid
siganids1045303siganids
sighed113712053sig_hed
sighted123111523sighted
sigil63515503sig__il
siglos7311473siglo_s
sigma84513833sigm__a
sigmas94111363sigm_as
sigmate10710143sigmate
signed83413753sig_ned
signior835043signior
signor73510353signo_r
signora8348503signora
signore8329093signore
signori8347893signori
signors83410913signors
signory11427523signory
siloed74615303si_loed
silurid837013silurid
siluroid945053siluroid
simlin8311733si_mlin
simony1137903si_mony
simoom1037503si_moom
simoon858063si_moon
sinusoid944383sinusoid
sirloin747593sirloin
sistroid947263sistroid
sixfold1842723sixfold
sixmo1448303sixmo__
sixmos1534813sixmo_s
sloid64619713s__loid
sparoid102311543sparoid
spiroid10219823spiroid
sporoid102310733sporoid
steroid81314863steroid
styloid1137553styloid
timid84815733ti_m_id
viroid10411523vi_roid
viscoid1337023viscoid
xiphoid2045923xiphoid
zincoid1946663zincoid
zygoid2045943zyg_oid

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 Limit134027846.43620824.6
3Display Results84840.0332545.5
 (SQL Overall)178691846.87525991.4
 
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.