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

95 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
guaiacs105435(None) 
guaiac946151guaiac_
guaiacol1151862guaiacol
guaiacols1251452guaiacols
guaiacum1361822guaiacum
guaiacums1471102guaiacums
guanaco1064582guanaco
guanacos1163812guanacos
guanays1134952guanays
guavas1037162guava_s
umiacs1035662_umiacs
burials93612083burials
celiacs11157893celiacs
cubics123810163cubi_cs
dulias71212743dulia_s
durians839573durians
gains65729513g_ai_ns
gaits65726013g_ai_ts
galahs105512673g_alahs
galas65731643g_ala_s
galyacs1335273galyacs
gamas85431363g_ama_s
gamays126310913g_amays
gavials1136603gavials
gayals1039513g_ayals
gazars164811553g_azars
gharials1245123gharials
glaires84010133glaires
glairs75211333glai_rs
glaives11347833glaives
glias64618493g_lia_s
graals74112913gra_als
grahams1335333grahams
grails77518783grai_ls
grains74223093grai_ns
gramas94317203grama_s
guaco85012163gu__aco
guacos94410313gua_cos
guaiocum1371613guaiocum
guaiocums1451093guaiocums
guanase836213guanase
guanases936233guanases
guanay1037913guana_y
guanines989773guanines
guanins8810013guanins
guanos73811993gua_nos
guans64419443gu__ans
guarana886303guarana
guaranas995943guaranas
guarani8106273guarani
guaranis996863guaranis
guardians1143913guardians
guards84611573gua_rds
guars65021053gu__ars
guava938583guava__
guffaws1762273guffaws
guides84118283gu_ides
guids75516153gu_i_ds
guilds8388353gu_ilds
guiles73919283gu_iles
guilts74111233gu_ilts
guiros7389093gu_iros
guises74216313gu_ises
guitars8116863guitars
gulags837543gu_lags
gummas114810513gumma_s
gunites8313123gunites
iguanas835383iguana_s
iguanians1042583iguanians
kaiaks937043_kaiaks
laics76419253_lai_cs
maniacs114313063maniacs
musics103911783musi_cs
naiads739013_naiads
nubias8310093nubia_s
oomiacs1135683oomiacs
quaich2047693quai_ch
quaichs2144633quaichs
quaighs2043493quaighs
quails153412643quai_ls
quais144618393quai__s
quasars1646903quasars
raias54631123_raia_s
ruanas6311263ruana_s
rupiahs1253333rupiahs
sumacs105512103su_macs
triacs83913223_triacs
tunics83811263tuni_cs
umiac938963_umiac_
umiack1435173_umiack
umiacks1534013_umiacks
umiaks1244953_umiaks
umiaqs1733003_umiaqs
urials64415193_urials
zodiacs1943423zodiacs

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 Filter1786911340270.423422437.4
2DLD Change Limit134027956.75019855.9
3Display Results95950.0303166.7
 (SQL Overall)178691957.20324807.9
 
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.