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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

82 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
kyak10521363(None) 
kayak1138361kayak
kyack13468261kyack
kyaks11459161kyaks
kyar116916841kyar
kyat116025521kyat
yak107038561_yak
arak86929572arak
ayah108022992ayah
beak106534382beak
cyan96419622cyan
dak86340692_dak
dhak125512032dhak
dyad96415452dyad
eyas76427432eyas
flak116026172flak
ka69145082k_a_
kaas86531842kaas
kab97145852k_ab
kae76744542k_ae
kaf106845512k_af
kaiak8310352kaiak
kaka76518682k_aka
kaki76520912k_aki
kas77058582k_as
kat77468292k_at
kay106745542k_ay
kayaks1236332kayaks
kayo116417552kayo
kays116032192kays
kbar106514652kbar
kea76540912kea_
keas86337092keas
keck94920712keck
keek75624972keek
khaf145319602khaf
khaki1157642khaki
khan115819142khan
khat116730722khat
kick96026072kick
kink76034402kink
kirk76221572kirk
klik74412652klik
knack104311042knack
knap105815402knap
knar85818722knar
koa76737772koa_
koan85425032koan
koas85635092koas
konk79320612konk
kook75822602kook
kulak858822kulak
kvas117015942kvas
kyacks14416062kyacks
kyars124813962kyars
kyats125012442kyats
kye107327272ky_e
kyes115124932kyes
kyte117017762kyte
leak86233712leak
oak76238652_oak
peak106535202peak
pya87023752pya_
pyas96225702pyas
rya67622012rya_
ryas77224612ryas
soak87227662soak
teak85930842teak
weak117126302weak
ya510251502_ya_
yack135425972_yack
yag76947732_yag
yah99046352_yah
yaks116025202_yaks
yam87448992_yam
yank115423672_yank
yap85949822_yap
yar67253832_yar
yaw97145152_yaw
yay96948712_yay
yok107335242_yok
yuk106725602_yuk

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 Filter178691298720.280638182.1
2DLD Change Limit29872820.84335435.3
3Display Results82820.0165125.0
 (SQL Overall)178691821.139156884.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.