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

68 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
gazanias184573(None) 
gazania1746111gazania_
galabias1137732galabias
galangas1046172galangas
abasias9711013_abasias
acacias11510393_acacias
acapnias1255683_acapnias
alanins7315803_alanins
amanitas1048523_amanitas
asanas6514113_asan_as
ataxias14189343_ataxias
atonias73315993_atonias
azaleas1636993_azaleas
azans146516883_azan__s
bananas93312223banan_as
cabanas112413033caban_as
daphnias1444683daphnias
egomanias12125993egomanias
fazendas2143073fazendas
galabia1038313galabia_
galabiyas1542513galabiyas
galanga936013galanga_
galangal1043893galangal
galangals1142903galangals
galateas937123galateas
galaxies1637163galaxies
galenas83310333galen_as
gambias125010723ga_mbias
ganjas14149113g__anjas
gardenias1145403gardenias
gazaboes2043863gazaboes
gazabos1944453gaza_bos
gazars164811553gaza__rs
geranial949283geranial
geranials1045913geranials
goannas836223g_oannas
granitas92610223g_ranitas
guanins8810013g_uanins
guaranas995933guaran_as
guaranies10127123guaranies
guaranis996863guarani_s
hazanim2164603hazani_m
hazans183411653hazan__s
jacanas1638263jacan_as
latakias1245583latakias
mahonias1348053mahonias
malangas1136863malangas
malarias10313753malarias
mananas93414733manan_as
manias84029033__manias
manzanitas2152343manzanitas
marantas10310023marantas
naganas847983nagan_as
paranoias11410443paranoias
ratafias1145323ratafias
ratanies8312923ratanies
savannas1143733savannas
tabanids1144963tabanids
taenias7311283ta_enias
tarantas839193tarantas
titanias847103titanias
uranias72113813_uranias
valonias1147473valonias
wakandas1643413wakandas
zamias174212923__zamias
zananas16319563zanan_as
zanies153219673__zanies
zanzas1487053__zanzas

Search took 8 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 Filter1786911461620.1701051123.5
2DLD Change Limit146162687.58019282.6
3Display Results68680.0164250.0
 (SQL Overall)178691687.76623009.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.