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 “myope” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

49 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
myope12401097(None) 
mope86838041m_ope
myopes13419961myopes
myopy15457351myopy
cope86847382_cope
dope76038892_dope
elope75219342elope
grope84821612grope
hope96639672_hope
hype125519812hy_pe
lope65941922_lope
metope10611122metope
mode75840302m_ode
moke106234222m_oke
mole66251832m_ole
mome85239352m_ome
moose76327192moose
mop76950822m_op_
moped105424732m_oped
moper94925922m_oper
mopes95134982m_opes
mopey124821822m_opey
mops85940132m_ops
mopy115721972m_opy
more67154522m_ore
mote67048082m_ote
moue65835572m_oue
move96630722m_ove
myoid11512982myoid
myoma1239272myoma
myopia13318432myopia
myopic15308462myopic
myopies14309712myopies
myoses114013842myoses
nope65934192_nope
ope56845242__ope
pope85535612_pope
pyrope132810532pyrope
rope65542912_rope
scope94821482scope
slope75823562slope
stope74727242stope
tope65946382_tope
trope75725802trope
type96223742ty_pe
yipe96722172_yipe
yoke115626392_yoke
yore76335942_yore
yowe106728742_yowe

Search took 2 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 Filter178691538000.0961861364.6
2DLD Change Limit53800491.62333148.5
3Display Results49490.000 
 (SQL Overall)178691491.719103950.6
 
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.