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 “simioid” 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
simioid104799(None) 
oidioid946052oidioid
sialoid8310962sialoid
sigmoid1146112sigmoid
simious939802simious
cirsoid1038123cirsoid
cissoid1037343cissoid
cymoid1459473cym_oid
diploid11310293diploid
discoid11311243discoid
fibroid1337243fibroid
gobioid1146023gobioid
hemoid12313513hem_oid
histoid1139823histoid
hominid13249533hominid
hominoid1446773hominoid
imid76122293_im__id
imidic11358203_imidic
lianoid837533lianoid
limited102310233limited
limpid11389753lim_pid
limuloid1143983limuloid
lipoid9411043li_poid
lithoid1148773lithoid
mimeoed1235193mimeoed
myoid11512993__myoid
nimious937663nimious
nimrod934873nimro_d
opioid9310083_opioid
saiyid10167413s_aiyid
sarcoid10310453sarcoid
schizoid2344353schizoid
scincoid1344753scincoid
sciuroid1144403sciuroid
semiarid1147793semiarid
semifit1249973semifit
semimild1344113semimild
semiosis1059873semiosis
semiotic12710633semiotic
semisolid1254723semisolid
semiwild1443713semiwild
sialid7314943si_alid
siganid947203siganid
sigloi737743sigloi_
sigmoids1244453sigmoids
silicic1147603silicic
silicide1147833silicide
siloed74615303si_loed
silurid837013silurid
siluroid945053siluroid
simian8811163simi_an
simians959203simians
similar937853similar
simile83115633simi_le
similes92915233similes
simitar936733simitar
simlin8311733sim_lin
simony1137903sim_ony
simoom1037503sim_oom
simooms1135573simooms
simoon858063sim_oon
simoons937943simoons
sinusoid944383sinusoid
sirloin747593sirloin
sistroid947263sistroid
sixfold1842723sixfold
sloid64619713s__loid
smiled93716433s_miled
somitic111512633somitic
sparoid102311543sparoid
spiroid10219823spiroid
sporoid102310733sporoid
steroid81314863steroid
stimied10310623stimi_ed
styloid1137553styloid
timid84815733tim__id
vibrioid1444403vibrioid
viroid10411523vi_roid
viscoid1337023viscoid
xiphoid2045923xiphoid
zincoid1946663zincoid

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 Limit134027815.95322514.2
3Display Results81810.0302700.0
 (SQL Overall)178691816.38927968.5
 
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.