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

121 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
syphered175501(None) 
cyphered1934651cyphered
sphered133512311s_phered
ciphered1637052ciphered
hyphened2044692hyphened
speered103614812s_peered
sphere113313662s_phere_
spheres123114352s_pheres
spiered104412462s_piered
supered10316122sup_ered
sypher14317082sypher__
syphers15317272sypher_s
syphoned1745732syphoned
adhered1239233_adhered
bothered142110393bothered
capered123014043cap_ered
cipherer1545573cipherer
cohered133514693_cohered
coppered153410543coppered
coshered14610293coshered
cypher16306593cypher__
cyphers17316753cypher_s
dithered13189293dithered
ensphered1565283ensphered
fathered151510433fathered
gathered13149383gathered
inhered11313163_inhered
insphered1564783insphered
kashered1636403kashered
kippered17255623kippered
koshered1636063koshered
lappered13288213lappered
lathered121512333lathered
lechered1437523lechered
lippered13287953lippered
loppered13326753loppered
mothered142310103mothered
ochered132610283_ochered
oystered1236923oystered
papered122513173pap_ered
peered93819493__peered
peppered1236133peppered
pothered142311043pothered
rapiered1136053rapiered
sabered103213023s_abered
sacheted14127833sacheted
saggered11237553saggered
saphead1357773saphe_ad
sapheaded1644183sapheaded
sceptered1444723sceptered
schemed1577753s_chemed
scuppered1643933scuppered
sered65737293s___ered
severed113513863s_evered
sewered112911243s_ewered
shared105829063s__hared
sheared114516003s__heared
sheered113515453s_heered
shepherd1744373shepher_d
shepherded2052263shepherded
sherd96321153s__her_d
shewed134716183s__hewed
shivered15177103shivered
shored105723653s__hored
showered1537013showered
shred98125613s__h_red
silvered12237563silvered
simmered1336863simmered
simpered1338253simpered
sintered92213903sintered
siphoned1446413siphoned
sistered92612803sistered
skewered1634213skewered
skippered1843433skippered
slathered13148553slathered
slavered12188033slavered
slippered1434823slippered
slithered13136623slithered
slivered12218103slivered
smothered1545683smothered
sneered83113973s_neered
sobered102912433s_obered
soldered1038153soldered
spared95427493s_p_ared
sparred104512863s_parred
speared104314423s_peared
speed85526623s_p_e_ed
speeded113310423s_peeded
speeled103712453s_peeled
speired103811103s_peired
spewed125512333s_p_ewed
sphene113412403s_phene_
sphenes123013163s_phenes
spheral1238423s_pheral
spheric14510073s_pheric
spherier1337783s_pherier
spheroid1447283s_pheroid
sphery14318883s_pher_y
spieled104811883s_pieled
spired94921863s_p_ired
spoored104411293s_poored
spored94821793s_p_ored
spurred103610623s_purred
steered83615253s_teered
stoppered1444473stoppered
suckered1537833suckered
suffered1536733suffered
sulphured1542923sulphured
summered1338143summered
sundered10312153sundered
swithered16135463swithered
syphering18175733syphering
tapered102612933tap_ered
telphered1544223telphered
tethered1238493tethered
tochered1437913tochered
unsphered1556103unsphered
ushered1139153_ushered
withered15169433withered
wuthered15157433wuthered
zippered22244823zippered

Search took 8 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 Limit1461621217.20020300.3
3Display Results1211210.0502420.0
 (SQL Overall)1786911217.67323288.3
 
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.