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

116 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
gallicas113693(None) 
gallica1047461gallica_
gallican1155331gallican
galletas9308132galletas
galliass935422galliass
gallic9411642gallic__
gallicism1444282gallicism
gallies84122712galli_es
galliots9228682galliots
galliums1145962galliums
galliwasp1541652galliwasp
garlics1038012garlic_s
agallochs1541583agallochs
alias55834603_a_li_as
aliyas93911803_a_liyas
allicin949953_allicin
allicins1049653_allicins
allies63827673_alli_es
alliums957973_alliums
alnicos985533_alnicos
alpacas1137073_alpacas
arnicas939543_arnicas
ballies93725743balli_es
basilicas1343733basilicas
calices114321693ca_lices
calicos113913493ca_licos
callas84526753call__as
callings113613833callings
dahlias1135723dahli_as
dalliers93610613dalliers
dallies84023193dalli_es
galabias1137733galabias
galabiyas1542513galabiyas
galangas1046173galangas
galas65731643ga_l__as
galateas937133galateas
galeas74618513ga_l_eas
galenas83310343ga_lenas
galenical1244673galenical
galenicals1352333galenicals
galilees936333galilees
galiots82311323ga_liots
gallants93310373gallants
gallates92815523gallates
galleass935053galleass
galleins9258693galleins
galleons9258443galleons
gallerias1047133gallerias
galleta8399643galleta_
gallets83517403gall_ets
galleys11369713gall_eys
galliard10125753galliard
galliards1194543galliards
gallicisms1543993gallicisms
gallicize2164993gallicize
gallicizes2284833gallicizes
gallied94115003galli_ed
galling93921963galli_ng
galliot82214133galli_ot
gallipot1145943gallipot
gallipots1243773gallipots
gallium1037943galli_um
gallivant1344493gallivant
gallivants1442603gallivants
galliwasps1651303galliwasps
gallnuts943923gallnuts
gallons83015953gall_ons
galloons9289703galloons
galloots9268963galloots
gallops103211653gall_ops
gallous82813953gall_ous
gallows113513513gall_ows
galls64729323gall___s
gallus74313203gall__us
galluses936963galluses
galyacs1335273galyac_s
gambias125010733gambi_as
garlic9310043garlic__
garlicky1842123garlicky
gillies84120963gilli_es
glias64618493g__li_as
gullies84717313gulli_es
halloas104318463hall_oas
hallucal1343483hallucal
halluces1335613halluces
kalmias1347973kalmi_as
killicks1354873killicks
maiolicas1343973maiolicas
majolicas2042573majolicas
malaccas1445163malaccas
malices114316623ma_lices
mallings113413093mallings
pallia83015593palli_a_
pallial92911253palli_al
palliums1236703palliums
papricas1447053papricas
pollical1247953pollical
pollices12410753pollices
ralliers84010833ralliers
rallies73823343ralli_es
replicas1237093replicas
rollicks1444893rollicks
salinas73116093sa_linas
salivas10309603sa_livas
salliers83613343salliers
sallies73227813salli_es
salvias10279933salvi_as
silicas9310603_silicas
talliers83711373talliers
tallies73624603talli_es
tallis63319963talli__s
tallises82713263tallises
talliths11377433talliths
tallits73215993talli_ts
wallas95719393wall__as
wallies103320743walli_es

Search took 9 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.406440125.6
2DLD Change Limit1461621167.79618748.3
3Display Results1161160.0462521.7
 (SQL Overall)1786911168.24821664.8
 
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.