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

212 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
sigmate1071014(None) 
inmate82917362_inmate
ligate72519252lig_ate
migrate101314172migrate
mismate111415352mismate
shipmate1546152shipmate
sigma84513832sigma__
sigmas94111362sigma_s
signage937772signage
sinuate7412162sinuate
situate7410782situate
stigmata1144672stigmata
stomate9313122stomate
summate113611662summate
agate66525153_ag_ate
agemate101210583agemate
agitate8312063agitate
agnate73314883_agnate
airdate8311323airdate
animate91617213animate
bedmate1239433bedmate
binate8419773bi_nate
bistate9313823bistate
bregmate1345533bregmate
bromate11313553bromate
ciliate9514603ciliate
cirrate92413493cirrate
citrate92216803citrate
climate11312833climate
cognate10312203cognate
coinmate1239063coinmate
comate104124843_comate
cremate113816183cremate
designate1147113designate
diamante1186423diamante
dictate10311663dictate
digitate1098683digitate
dilate73220693di_late
disrate81418523disrate
dogmata1145143dogmata
emigrate1149603emigrate
enigmata1143663enigmata
ergate7315143erg_ate
estimate10912003estimate
fermate122813003fermate
figeater1236953figeater
figurate1237193figurate
filiate10414233filiate
fissate103010033fissate
fixate1638733fi_xate
formate123115093formate
frigate11311063frig_ate
gate55746573__g_ate
gemmate12418383gemmate
grate64932883__grate
hamate113319833_hamate
hogmane1336343hogmane
humate113214443_humate
ideate7313683_ideate
ignite71410583_ignite
image81411293_i_mage
imamate1138103imamate
immane1038883_immane
ingate73018243_ingate
ingrate8715123ingrate
inmates92715783_inmates
innate63917313_innate
iodate7313503_iodate
irate55627983_i_rate
isolate7313923isolate
jugate14379463jug_ate
kismat123011673kismat_
kismats13257843kismats
legate72917453leg_ate
librate93214233librate
ligase7259913lig_ase
ligated92414143lig_ated
ligates82318383lig_ates
lignite81310303lignite
ligulate92510253ligulate
limbate1139213limbate
lineate7815153lineate
liquate1638423liquate
magmata1237463magmata
magnate10512703magnate
mammate104411273mammate
mate65154223___mate
migrated121110513migrated
migrates111112853migrates
misate81222693mi_sate
misdate101413963misdate
mismade12129353mismade
mismake15139373mismake
mismated131111333mismated
mismates121114563mismates
misrate91319143misrate
negate72915573neg_ate
nictate9310223nictate
nidate7313783ni_date
niobate937703niobate
nitrate72017013nitrate
nizamate1943533nizamate
ostomate1049573ostomate
palmate113215233palmate
picrate112014143picrate
pileate93815923pileate
pinnate93613743pinnate
pirate82322883pi_rate
plumate1149803plumate
primate111516283primate
ramate83921683_ramate
regmata1036193regmata
regrate82618663regrate
remate84428683_remate
rugate75813813rug_ate
saccate111311763saccate
samite83020603s_amite
sate45556103s___ate
satiate7315403satiate
savate9313783s_avate
schmatte1544473schmatte
scutate9310323scutate
seatmate1048573seatmate
sedate73019813s_edate
senate63725173s_enate
sensate7311893sensate
septate9511873septate
seriate73722473seriate
serrate73017543serrate
sfumato1253683sfumato
shipmates1645953shipmates
siamang1045333siamang
siamese936503siamese
sibilate1049533sibilate
sienite7312713sienite
sight94629293sig_ht_
sighted123111523sig_hted
sighter113412113sig_hter
sights103818013sig_hts
sigla64515203sigla__
sigmoid1146113sigmoid
signa66114703signa__
signages1037483signages
signal73711483signa_l
signaled1035393signaled
signaler945453signaler
signals8359163signals
signature1053763signature
signee73617233sig_nee
signet73621153signet_
signeted1035973signeted
signets83311503signets
signore8329093signore
silage72715303si_lage
silane62718053si_lane
silicate10312623silicate
silvae92811093silva_e
sima64730783si_ma__
simar74920813si_ma_r
simars84916933si_mars
simas75727553si_ma_s
simile83115633si_mile
simple104315173si_mple
simulate10311133simulate
sinkage1287263sinkage
sinuated938413sinuated
sinuates8310963sinuates
site47052413si___te
situated938033situated
situates8310373situates
sixte126216583si__xte
skate94721553s__kate
slate55438283s__late
smaze165012933s__maze
smite75224873s__mite
smote75820283s__mote
solate64526073s_olate
solvate102710213solvate
somata8312383s_omata
somite84519373s_omite
sorbate9311733sorbate
soulmate1047193soulmate
spate74731583s__pate
spicate113214193spicate
spinate93114813spinate
squamate1945783squamate
stagnate947243stagnate
state56237333s__tate
stigma9226763stigma__
stigmal10245923stigma_l
stigmas10206643stigma_s
stigmatic1445733stigmatic
stigmatize2254033stigmatize
stomata938533stomata
stomates10313343stomates
striate74218953striate
stylate10179773stylate
sublate9315363sublate
sulcate9314423sulcate
sulfate10311653sulfate
summae103911013summa_e
summated13298833summated
summates122610493summates
titrate72215573titrate
togate74515683tog_ate
vibrate122811523vibrate
violate10311553violate
virgate1138733virgate
vitiate103412953vitiate
vittate10409733vittate
wigmaker1843803wigmaker
zincate1838533zincate

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.406440125.6
2DLD Change Limit1340272127.12618808.2
3Display Results2122120.0762789.5
 (SQL Overall)1786912127.60823487.3
 
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.