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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

148 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
guaiac94615(None) 
guaiacs1054351guaiacs
guaiacol1151862guaiacol
guaiacum1361822guaiacum
guanaco1064582guanaco
guanay1037912guanay
guava938582guava_
guavas1037162guavas
umiac938962_umiac
audial7312993audial
aulic74420243auli_c
auric74521733auri_c
burial84117623burial
celiac101910433celiac
cubic114313423cubi_c
curia74523773curia_
curiae84518373curiae
curial84019153curial
dulia61014983dulia_
dulias71212743dulias
durian7312003durian
gaga66625553g_aga_
gaily95020973g_aily
gain56042163g_ai_n
gains65729513g_ains
gait56150193g_ai_t
gaits65726013g_aits
gala55635163g_ala_
galah95917633g_alah
galas65731643g_alas
galax135314463g_alax
galyac1235973galyac
gama77035523g_ama_
gamas85431363g_amas
gamay116419113g_amay
gamic103916203g_amic
gavial10310083gavial
gayal9312713g_ayal
gazar154612983g_azar
genial74917613genial
genic85119393geni_c
gharial1137343gharial
glacial1038143glacial
glair65313553glai_r
glaire74411293glaire
glairs75211333glairs
glairy10448273glairy
glaive10357933glaive
glia56423153g_lia_
glial66715433g_lial
glias64618493g_lias
gonia64117533gonia_
graal64316503gra_al
graham1237853graham
grail64622873grai_l
grails77518783grails
grain65126253grai_n
grains74223093grains
grainy103914213grainy
grama85620283grama_
gramas94317203gramas
grana65722093grana_
guaco85012163gua_co
guacos94410313guacos
guaiacols1251453guaiacols
guaiacums1471103guaiacums
guaiocum1371613guaiocum
guan55325583gu__an
guanacos1163813guanacos
guanase836213guanase
guanays1134953guanays
guanin7610803guanin
guanine8810543guanine
guanins8810013guanins
guano69213983gua_no
guanos73811993guanos
guans64419443gua_ns
guar56923293gu__ar
guarana886303guarana
guarani8106273guarani
guard74415543gua_rd
guardian1045113guardian
guards84611573guards
guars65021053gua_rs
guffaw1642793guffaw
guid66022823gu_i_d
guide75019883gu_ide
guids75516153gu_ids
guild75312753gu_ild
guile64521133gu_ile
guilt65125573gu_ilt
guiro63712093gu_iro
guise64717713gu_ise
guitar7117443guitar
gulag7310823gu_lag
gular6314833gu_lar
gumma105313103gumma_
gummas114810513gummas
gunite7414403gunite
gunman9299453gunman
gutta64613383gutta_
guttae73210583guttae
guying11379723guying
heliac111010893heliac
huic94818053hu_i_c
humic124113243humi_c
iguana735813iguana_
iguanas835383iguanas
iguanian943553iguanian
iliac75013493_iliac
kaiak8310353_kaiak
laic65931563_lai_c
ludic82912803ludi_c
maniac103917973maniac
music94316403musi_c
naiad6313403_naiad
nubia7311233nubia_
nubias8310093nubias
oomiac1037063oomiac
orgiac934993orgiac
pubic114513723pubi_c
pudic104614563pudi_c
quai134420393quai__
quaich2047693quaich
quaigh1935463quaigh
quail144314363quai_l
quails153412643quails
quaint15415173quaint
quais144618393quai_s
qualia1559563qualia_
quasar1536833quasar
raia46638383_raia_
raias54631123_raias
ruana5312423ruana_
ruanas6311263ruanas
runic73615773runi_c
rupiah1146213rupiah
sumac99514883su_mac
triac74116373_triac
tunic74018223tuni_c
tunica8379813tunica
umiack1435173_umiack
umiacs1035663_umiacs
umiak1137673_umiak
umiaq1656823_umiaq
urial54823023_urial
uric63624943_uri_c
zodiac1835303zodiac

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.406440125.6
2DLD Change Limit1127161485.03322395.4
3Display Results1481480.0463217.4
 (SQL Overall)1786911485.48532578.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.