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

80 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
tabla7331836(None) 
tablas83716161tablas
table75429601table
tala45938051ta_la
aba512850952_ab_a
abba810522652_abba
able66340532_able
ably99725132_ably
ala312463602_a_la
alba68328332_alba
atabal839742atabal
baba88828352bab_a
babka137812912babka
cabal95222152cabal
cabala103516912cabala
cable95329912cable
calla74827072calla
dobla84913642dobla
fable105824752fable
gable85325522gable
gala55635162ga_la
kabala124011552kabala
kibla1139832kibla
labia75219012labia
labra75415462labra
nala46930392na_la
qabala17399192qabala
rambla103510932rambla
sabal75422482sabal
sable74732162sable
sabra75317852sabra
stable83921642stable
stably113314122stably
tab57460322tab__
tabby125213892tabby
taber73825822taber
tabes76033922tabes
tabid84418262tabid
tableau966272tableau
tabled94020042tabled
tables84524882tables
tablet84227642tablet
taboo73418092taboo
tabor75518392tabor
tabs66842982tab_s
tabu66328492tab_u
tabular9279762tabular
tabuli839362tabuli
tabun75914372tabun
tabus74820922tabus
tael46030712tael_
taels56822072taels
tafia84215492tafia
taiga64115652taiga
tail45443652tail_
tails55634192tails
taka87623592ta_ka
talar56225382ta_lar
talas55935892ta_las
talc66226812ta_lc
tale46154162ta_le
tali46837162ta_li
talk86230092ta_lk
tall47240212ta_ll
talls55133432talls
tally84526862tally
tamal73522612tamal
tambala1138022tambala
tanga64923682tanga
tanka93817482tanka
tapa65129142ta_pa
taxa116820092ta_xa
tazza1338082tazza
tela45532972t_ela
tesla55612602tesla
tibia7312402tibia
tola45236332t_ola
tuba65422362tub_a
tubal75517202tubal
walla85321032walla

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.0931921408.6
2DLD Change Limit53800801.71631352.0
3Display Results80800.0165000.0
 (SQL Overall)178691801.82597912.9
 
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.