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 “bytalks” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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
bytalks163271(None) 
bytalk1533471bytalk_
balks114926292b__alks
stalks104614552_stalks
talks94322692__talks
uptalks1333722uptalks
attacks13126943attacks
baals76122703b_aal_s
backs135729623b__acks
balas76937213b__alas
balds85524643b__alds
bales76250083b__ales
balk105132223b__alk_
balky145418243b__alky
balls76236413b__alls
balms95723923b__alms
bals66354043b__al_s
banks115527903b__anks
barks115735813b__arks
basalts9358963basalts
basks115621763b__asks
batiks1239373bat_iks
battiks1337143battiks
battles94517683battles
baulks12429373b_aulks
beaks115326623b_ea_ks
becalms1335743becalms
bechalks1944793bechalks
befalls12349123befalls
begalls10319163begalls
betake124512703beta_ke
betakes134212523betakes
betas75528763beta__s
betels84515063betel_s
bethanks1765313bethanks
bialis83617163b_ialis
bialys11387913b_ialys
bilks115117893b__ilks
bipacks1745043bipacks
blacks144914953b_lacks
blanks124112893b_lanks
bleaks125112433blea_ks
borals86721913boral_s
botas75328783bota__s
botels84815803botel_s
bottles94216273bottles
branks124817383b_ranks
breaks124816423brea_ks
bubales113513343bubales
bubalis11359903bubalis
bubals103513843bubal_s
bulks115920613b__ulks
butanes9312743butanes
butles84423913but_les
buttals938503buttal_s
butyls1176753butyl_s
buybacks2144783buybacks
byelaws1533263byelaws
bylaws14415833byla_ws
bynames14256243bynames
bypass1345043bypa_ss
bypaths1743193bypaths
byplays1743103byplays
byrls105711233by_rl_s
bytes105217493byt__es
byways1734673bywa_ys
byworks1944543byworks
byzants2153223byzants
calks115421603__calks
catalos9414163catalos
catwalks1744793catwalks
chalks155412143_chalks
eyestalks16132343eyestalks
jaywalks2542143jaywalks
kyacks14416063ky_acks
kyaks11459163ky_a_ks
metals84520883metal_s
nyalas936903ny_alas
outasks1138173outasks
outtalks1236503outtalks
outwalks1535993outwalks
peptalks1653843peptalks
petals84719813petal_s
ratals64219583ratal_s
retacks132210713retacks
skywalks1742193skywalks
stacks124317263_stacks
stales65538293_stales
stalk94518003_stalk_
stalky13499303_stalky
stalls64019933_stalls
stanks104917703_stanks
tacks115430133__tacks
talas55935893__talas
talcs74817183__talcs
tales55451373__tales
talk86230093__talk_
talky126215683__talky
talls55133433__talls
taluks10418283__taluks
talus55423263__talus
tanks94624733__tanks
tasks94917583__tasks
totals63115163total_s
untacks1357503untacks
uptalk1234653uptalk_
vitals94514303vital_s
walks126218503__walks
yacks144419813_y_acks
yaks116025203_y_a_ks
yanks125316573_y_anks
yelks126413623_y_elks
yolks125412773_y_olks

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.420425454.8
2DLD Change Limit1340271136.29621287.6
3Display Results1131130.0333424.2
 (SQL Overall)1786911136.74926476.7
 
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.