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

89 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
traiks10401371(None) 
tracks124818841tracks
traik95418201traik_
trails64622511trails
trains64725341trains
traits65121981traits
tranks104017761tranks
araks94820882ara_ks
braids95015692braids
brails84621292brails
brains85125472brains
branks124817382branks
cracks144817002cracks
cranks125015312cranks
drails74716952drails
drains73719402drains
frails93716472frails
franks134912732franks
grails77518782grails
grains74223092grains
haiks125120932_haiks
kraits104912202kraits
paiks114719852_paiks
pranks124814722pranks
racks115028852_racks
raias54631122_raias
raids65827512_raids
rails55937402_rails
rains55140232_rains
rais45252622_rai_s
rakis95323442_rakis
ranks95225732_ranks
strains74218152strains
straits74916322straits
tacks115430132t_acks
tails55634192t_ails
tains54936322t_ains
talks94322692t_alks
tanks94624742t_anks
taroks106115282taroks
tasks94917582t_asks
teaks94222902tea_ks
terais64023512terai_s
thacks154311922thacks
thanks134313132thanks
traces85329932traces
track114823012track_
tracts85019072tracts
trades75724502trades
tragics10338082tragics
tragus749232tragus
traiked123310452traiked
trail55126772trai_l
train56529112trai_n
traipse935872traipse
trait56940842trai_t
tramps105114452tramps
trams75327672tra_ms
trank96222422trank_
tranqs155210312tranqs
trans54933042tra_ns
trapes85024462trapes
traps75727482tra_ps
trass56226472tra_ss
traves94222742traves
trawls94412392trawls
trays85623432tra_ys
treks96016852tr_eks
triacs83913222triacs
triads74513532triads
trials64319882trials
tricks125319012tricks
tries55742812tr_ies
trigs65423062tr_igs
trike95320162tr_ike
trikes105419492tr_ikes
trims75021472tr_ims
trios55528092tr_ios
trips74923362tr_ips
troaks104410602troaks
trocks123614632trocks
troika1035492troika
troikas1135032troikas
trois57226092troi_s
trucks124711972trucks
trunks10429752trunks
tupiks1235492tupiks
twains95811182twains
wracks154711112wracks

Search took 5 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.343520965.0
2DLD Change Limit82551894.22019561.8
3Display Results89890.0302966.7
 (SQL Overall)178691894.59338905.1
 
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.