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

61 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
gagakus134288(None) 
gagaku1243811gagaku_
abacus10349763_abacus
abakas123911743_abakas
acarus8312193_acarus
agamas97413453_agamas
agamous1037943_agamous
agapes95212413_agapes
agars66120643_aga_rs
agas55938843_aga__s
agates76121343_agates
agaves104611513_agaves
aggadas1055003aggadas
ankus91410683_a_nkus
araks94820883_arak_s
awakes135012473_awakes
bagass938933baga_ss
calamus1139243calamus
gaga66625553gaga___
gagers84021333gag_ers
gages74529973gag__es
gaggers103413663gaggers
gaggles103512593gaggles
gags66441063gag___s
galagos938143galagos
galahs105512673gala_hs
galas65731643gala__s
galaxes1538873galaxes
gallous82813953gallous
gallus74313203ga_llus
galyaks1534623galyak_s
gamas85431363gama__s
gamays126310913gama_ys
garages9314113garages
gaseous839503gaseous
gateaus866333gateaus
gavages1237683gavages
gawks136811633ga_wk_s
gayals1039513gaya_ls
gazabos1944453gazabos
gazars164811553gaza_rs
gigas75415583giga__s
gradus84411223g_radus
haikus13538293ha_ikus
hakus125114113__hakus
kabakas12367403kabakas
kagus105812033kag__us
kaiaks937043kaiak_s
kanakas10327213kanakas
karakul1042553karakul
karakuls1142083karakuls
kayaks1236333kayak_s
lagans75717783laga_ns
magus85318753mag__us
naganas847983naganas
padauks1443943padauks
pagans95717923paga_ns
ragas65326063raga__s
rakus94413673__rakus
sagas66025883saga__s
vagus96713813vag__us

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.390458182.1
2DLD Change Limit134027616.15621771.8
3Display Results61610.0163812.5
 (SQL Overall)178691616.56227231.2
 
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.