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

47 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
eyecups144282(None) 
eyecup1344491eyecup_
eggcups1341202eggcups
eyefuls1343842eyefuls
becaps123811403_becaps
checkups2142803checkups
cups85430823___cups
ecus65421463__ecu_s
eggcup1241833eggcup_
ejects15409953ejec_ts
elects83315003elec_ts
emeus76913333eme_u_s
erects84116183erec_ts
execs14539723exec__s
execute1636783execute
executes1736533executes
eyebars1245333eyebars
eyedrops1443163eyedrops
eyeful1235903eyefu_l
eyeless1058053eyeless
eyelets1057523eyelets
eyelids1135943eyelids
eyers86521333eye__rs
eyes75837883eye___s
getups9346853_getups
hiccups1643223hiccups
icecaps1343863icecaps
letups8317683_letups
lyceums1442403lyceums
oilcups1143333oilcups
precuts111710473precuts
recaps103615733_recaps
recoups1188843_recoups
recurs83315803_recurs
recuts83817373_recuts
scups95316653__scups
setups83910463_setups
syrups11277953sy_rups
teacups1133963teacups
toecaps1135553toecaps
yaups105910743_y_aups
yecchs16414953_yecchs
yechs136112583_yec_hs
yelps105712993_ye_lps
yeps95924403_ye__ps
yeuks125110093_ye_uks
yups96121603_y__ups

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 Limit134027475.96622465.1
3Display Results47470.0162937.5
 (SQL Overall)178691476.38827972.9
 
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.