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

111 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
syrinxes1829442(None) 
syringes122810211syringes
serines74229542serin_es
shrines104618692shrin_es
sphinxes20334402sphinxes
springes114014032springes
syringas12285952syringas
syringe11349472syringe_
syringed13377582syringed
syrinx1637142syrinx__
astringes1038333astringes
brines85028853_brin_es
brinies93317913_brinies
bylines1239243bylin_es
byrnies12378573byr_nies
cringes103215503_cringes
eserines8413743eserin_es
eyries93816813eyri__es
fringes113514103_fringes
gyrenes11267523gyren_es
hyraxes2045703hyr_axes
jinxes20428233__jinxes
kyries133411373kyri__es
larynxes1842453larynxes
lynxes1634323ly__nxes
lysines10369093lysin_es
marines93928013marin_es
minxes154612983__minxes
murines93718223murin_es
princes113015143_princes
purines94420763purin_es
pyrenes123511223pyren_es
pyrexes19305843pyr_exes
pyrites12812203pyri_tes
pyrones123113303pyron_es
rinses64720383__rinses
sabines94318483sabin_es
salines74029413salin_es
sardines92815563sardin_es
sarins63932623sarin__s
savines104417633savin_es
scribes113713203scri_bes
scries85226823scri__es
scrieves13387613scrieves
scrives124414273scri_ves
seines65029903s_ein_es
serenes73222903seren_es
seriates82620673seriates
series64540973seri__es
serine65432673serin_e_
seringas9339003seringas
serins64029673serin__s
shines95028913s_hin_es
shrieves14297093shrieves
shrikes144412393shri_kes
shrine94920053shrin_e_
shrined114112413shrin_ed
shrinker15236363shrinker
shrinkers16205383shrinkers
shrinks14397913shrin_ks
shrives134416173shri_ves
sines55954823s__in_es
singes74326853s__inges
sixes124526363s__i_xes
skylines1535703skylin_es
sordines92414073sordin_es
sorings83817253sorin_gs
sorites73825243sori_tes
sozines16611263sozin_es
sphinges14267483sphinges
sphynxes23292423sphynxes
spines85132033s_pin_es
splines94718893splin_es
springe103913983springe_
springed123911323springed
springer113311753springer
springers12309983springers
springs104415923sprin_gs
sprinkles1534923sprinkles
sprinted113411163sprinted
sprinter103810813sprinter
sprinters11329363sprinters
sprints94113773sprin_ts
sprites94220333spri_tes
spritzes1946943spritzes
stranges94516763stranges
striates83417083striates
strides84520393stri_des
strifes104716583stri_fes
strikes114719093stri_kes
stringed102911873stringed
stringer93812943stringer
stringers104210643stringers
strings84617133strin_gs
stripes95320573stri_pes
strives104119373stri_ves
styraxes1833493styr_axes
styrenes11116623styren_es
supines94216383supin_es
surtaxes1536513surtaxes
swinges113413423s_winges
syenites1138943syenites
sylvines14215903sylvin_es
syntaxes1843633syntaxes
syrens94911993syren__s
syrettes1136963syrettes
syringa11366353syrin_ga
syringeal1343003syringeal
trines64132563_trin_es
urines64724123_urin_es
vernixes1836053vernixes

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 Limit1461621118.12317993.6
3Display Results1111110.0931193.5
 (SQL Overall)1786911118.63920684.2
 
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.