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

118 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
satyrid113723(None) 
satyric1237491satyric
satyrids1245621satyrids
katydid1642592katydid
saiyid10167412saiy_id
satiric939242satiric
satori6415832satori_
satoris7317232satoris
satyr848482satyr__
satyrs937962satyr_s
sayid95516722sa_y_id
sayyid13185352sa_yyid
acarid95017063_acarid
acrid86920103_a_crid
arid57642713_a__rid
ascarid103910713ascarid
asteria7316173asteria
asteroid9511173asteroid
astride8311973ast_ride
atria56022333_at_ria
atrip75315743_at_rip
attrit6315743_attrit
atypic13337653_atypic
butyric1445123butyric
butyrin1245813butyrin
catbird1235243catbird
catered103117763catered
chytrid1645713chytrid
daturic1047003daturic
elaterid948613elaterid
fatbird1344033fatbird
hatred104814333hat_red
hayride1437323ha_yride
iatric8312153iat_ric
katydids1741603katydids
lampyrid1642903lampyrid
laterad8310833laterad
latria62313583lat_ria
martyred1434283martyred
matrix1539833mat_rix
mattoid1079273mattoid
matured10310033matured
natured838963natured
nitrid72812233nit_rid
pagurid11105433pagurid
papyri1334903papyri_
putrid9311163put_rid
sabered103213023sabered
sabred95916533sa_bred
sacred94917103sa_cred
safari91110223safari_
safaried1236253safaried
safaris101110663safaris
said55742113sa___id
saiyids11174893saiy_ids
salaried9311023salaried
salpid9510873sa_lpid
sangria838113sangria
santeria8311643santeria
sapid84720933sa__pid
sarcoid10310453sarcoid
sard55344243sa__r_d
sari45444043sa__ri_
sarin55239253sa__rin
saris54544953sa__ris
sarod65325873sa__rod
sartorii845573sartorii
satanic939933satanic
satara6315533satar_a
sataras7315053sataras
sated66238533sat__ed
sati45539323sat__i_
satin55935213sat__in
satire63218003satir_e
satires72617573satires
satirise8310683satirise
satirised1046543satirised
satirist8313503satirist
satirize1749693satirize
satirized1957883satirized
satis55633673sat__is
satrap86212553sat_rap
saturniid1051983saturniid
satyrical1445033satyrical
satyrlike1653513satyrlike
savarin10310003savarin
savored1158343savored
sayed96127143sa_y_ed
sayids104310973sa_y_ids
sayyids14193833sa_yyids
sciurid1044923sciurid
silurid837013silurid
spagyric1642053spagyric
sparid94016933s_parid
staid66722073s_t_aid
stared75429873s_tared
starred85013453starred
stayed104817273stay_ed
steric8317063s_teric
steroid81314853s_teroid
stolid74213173s_tolid
stored75524213s_tored
storied8515163s_toried
stria55723203s_t_ria
stride75420963s_t_ride
strip77524333s_t_rip
stupid937593s_tupid
styed95815483s_ty_ed
styled105613103s_tyled
styli83911173s_tyli_
styloid1137543s_tyloid
stymie1137623s_tymie
stymied1335653s_tymied
styrax1675243s_tyrax
subarid10310653subarid
sutured8310373sutured
tyred95816433__tyred
watered113014953watered

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271188.50015767.9
3Display Results1181180.0502360.0
 (SQL Overall)1786911188.70620525.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.