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

76 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
daube8501530(None) 
daub77423441daub_
daubed104611781daubed
dauber94112011dauber
daubes94913701daubes
daubs85014561daubs
dauby115211221dauby
abbe87627192_abbe
adobe84814712adobe
babe86835822ba_be
barbe95328282barbe
baubee103215992baubee
bauble103813212bauble
cause75225352cause
cube85830212_cube
dab67455562da_b_
dabbed124416142dabbed
dabber114816962dabber
dabble114515192dabble
dabs77139402da_bs
dace76934922da_ce
dale55643982da_le
dame77140312da_me
dance85223132dance
darb76033532darb_
darbs85323262darbs
dare55848862da_re
date56443322da_te
daubers104610422daubers
daubery13396212daubery
daubier1037102daubier
daubry12445482daubry
daunt65929082daunt
daut56443562dau_t
dauted84114932dauted
dautie72914702dautie
dauts67822242dauts
daybed13438672daybed
daze147327232da_ze
deuce84517492deuce
double94013992double
doubt8720092doubt
douce85518422douce
douse66329722douse
drub75920132drub_
drubs85913832drubs
drupe85012992drupe
druse64817662druse
dub66642202d_ub_
dubs78432192d_ubs
duce76933502d_uce
dude65629662d_ude
due45249862d_u_e
duke95628102d_uke
dune56137582d_une
dupe76630602d_upe
dure56341812d_ure
fauve114712072fauve
gambe106219212gambe
gauge76117902gauge
gauze155712972gauze
haute89521612haute
jambe165314752jambe
jube136322782_jube
lube64731562_lube
mabe85733362ma_be
mauve104013272mauve
maybe12311132maybe
nabe66029492na_be
pause75021832pause
rube65532012_rube
sabe66140572sa_be
sauce75121652sauce
saute55028082saute
taupe7314162taupe
tube65828662_tube

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.310576422.6
2DLD Change Limit53800761.64032804.9
3Display Results76760.0332303.0
 (SQL Overall)178691761.98390111.4
 
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.