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

84 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
tablet8422764(None) 
cablet104429461cablet
table75429601table_
tabled94020041tabled
tables84524891tables
tablets94714381tablets
abet610547942_ab_et
able66340532_able_
abled86926832_abled
abler75624312_abler
ables75935542_ables
ablest84721832_ablest
aglet65534142_aglet
ballet84733972ballet
blet66247672__blet
cable95329912cable_
cabled114819872cabled
cabler104519172cabler
cables104527552cables
cablets114216342cablets
callet84536762callet
camlet104426582camlet
caplet104226812caplet
eaglet73722582eaglet
fable105824752fable_
fabled124216382fabled
fabler116115812fabler
fables114921672fables
gable85325522gable_
gabled105518452gabled
gables94222332gables
gallet73630852gallet
giblet93418892giblet
goblet93219482goblet
hamlet113722792hamlet
haslet93222712haslet
labret8320222labret
mallet84433052mallet
palet74650802pa_let
pallet84232652pallet
rabbet103818652rabbet
riblet84222442riblet
sable74732162sable_
sables85026692sables
sallet63734542sallet
samlet84126562samlet
stable83921642stable_
stabled103514952stabled
stabler94014932stabler
stables93219072stables
stablest103312942stablest
starlet71620122starlet
sublet82827242sublet
tabaret92717312tabaret
tabbed114215362tabbed
taber73825822tab_er
tabes76033922tab_es
tabla73318362tabl_a
tablas83716162tablas
tableau966282tableau
tableted1137532tableted
tabletop1243412tabletop
taboret92916112taboret
tabued94310402tabued
tacet75840022ta_cet
tacket124627492tacket
tailed74424662tailed
tailer63823732tailer
tale46154162ta_le_
talent6323322ta_lent
taler56034872ta_ler
tales55451372ta_les
taller63721962taller
tallest7317092tallest
tallit63422732tallit
tappet103820112tappet
target75028912target
tartlet72218482tartlet
tasset65925312tasset
toilet66228092toilet
tonlet62924702tonlet
valet84337872va_let
varlet9423502varlet
wallet93327092wallet

Search took 4 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 Filter178691825510.423422437.4
2DLD Change Limit82551842.71630394.3
3Display Results84840.0332545.5
 (SQL Overall)178691843.17256333.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.