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

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
gagaku124381(None) 
gagakus1342881gagakus
gaga66625552gaga__
abaka114313823_abaka
aga410447233_aga__
again65218123_again
agama85815583_agama
agape85614843_agape
agar58726413_aga_r
agars66120643_agars
agas55938843_aga_s
agate66525153_agate
agave95314033_agave
agaze156113663_agaze
aggada955223aggada
arak86929573_arak_
araks94820883_araks
awake125014783_awake
bagass938933bagass
gag57753633gag___
gage65936103gag__e
gaged85522313gag_ed
gager74726293gag_er
gagers84021333gagers
gages74529973gag_es
gagged104817153gagged
gagger95016513gagger
gaggle93412623gaggle
gaging94718403gaging
gagman103811243gagman
gagmen103910413gagmen
gags66441063gag__s
gala55635163gala__
galago838903galago
galah95917633gala_h
galahs105512673galahs
galas65731643gala_s
galax135314463gala_x
galaxy17476313galaxy
galyak1445333galyak_
galyaks1534623galyaks
gama77035523gama__
gamas85431363gama_s
gamay116419113gama_y
gamays126310913gamays
garage8314513garage
gateau778113gateau
gavage1137193gavage
gawk126716693ga_wk_
gawks136811633ga_wks
gawky16569993ga_wky
gayal9312713gaya_l
gayals1039513gayals
gazabo1834833gazabo
gazar154612983gaza_r
gazars164811553gazars
giga66720943giga__
gigas75415583giga_s
haiku126113693ha_iku
haku116923893__haku
kabaka11348503kabaka
kagu95418113kag__u
kaiak8310353kaiak_
kaiaks937043kaiaks
kanaka9357523kanaka
karakul1042553karakul
kayak1138363kayak_
kayaks1236333kayaks
lagan66520343laga_n
lagans75717783lagans
nagana748943nagana
padauk1335643padauk
pagan86121163paga_n
pagans95717923pagans
raga55930813raga__
ragas65326063raga_s
raku85423773__raku
saga55331173saga__
sagas66025883saga_s
vagal94613633vaga_l
vagary1337333vagary

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit112716815.11022057.9
3Display Results81810.0136230.8
 (SQL Overall)178691815.51632395.0
 
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.