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

81 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
cablet10442946(None) 
cable95329911cable_
cabled114819871cabled
cabler104519171cabler
cables104527551cables
cablets114216341cablets
callet84536761callet
camlet104426581camlet
caplet104226811caplet
tablet84227641tablet
abet610547942_ab_et
able66340532_able_
abled86926832_abled
abler75624312_abler
ables75935542_ables
ablest84721832_ablest
aglet65534142_aglet
ballet84733972ballet
blet66247672__blet
cabaret112519042cabaret
cabbed135416262cabbed
caber95126832cab_er
cabinet11318902cabinet
cablers114416712cablers
cabmen123610652cabmen
cachet134526412cachet
cadet85339332ca_det
called94126732called
callee84327292callee
caller85125482caller
callets93821702callets
camlets114314622camlets
capelet11517072capelet
caplets114914522caplets
caret75360562ca_ret
carle74535702carle_
carles85435082carles
carnet84732872carnet
carpet104530092carpet
casket124820992casket
caules85927252caules
chalet113825992chalet
chaplet14512252chaplet
coble94823172coble_
cobles104622882cobles
collet84030362collet
culet76040342c_ulet
cullet84727312cullet
cutlet84924362cutlet
eaglet73722582eaglet
fable105824752fable_
fabled124216382fabled
fabler116115812fabler
fables114921672fables
gable85325522gable_
gabled105518452gabled
gables94222332gables
gallet73630852gallet
giblet93418892giblet
goblet93219482goblet
hamlet113722792hamlet
haslet93222712haslet
labret8320222labret
mallet84433052mallet
palet74650802pa_let
pallet84232652pallet
rabbet103818652rabbet
riblet84222442riblet
sable74732162sable_
sables85026692sables
sallet63734542sallet
samlet84126562samlet
scarlet91516942scarlet
sublet82827242sublet
table75429602table_
tabled94020042tabled
tables84524882tables
tablets94714372tablets
valet84337872va_let
varlet9423502varlet
wallet93327092wallet

Search took 3 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.1101624463.6
2DLD Change Limit82551812.72030349.6
3Display Results81810.0136230.8
 (SQL Overall)178691812.84362853.0
 
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.