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

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

174 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
guar5692329(None) 
gar47259901g_ar
gaur56723351gaur
gear55934971gear
gnar56021381gnar
guan55325581guan
guard74415541guard
guars65021041guars
gular6314831gular
afar76720782afar
agar58726412agar
ajar116217702ajar
alar46340072alar
ar211379382__ar
aura45836252aura
aurar54420252aurar
bar58070552_bar
bear66844642bear
boar66134292boar
buhr95315382buhr
bur55744692bu_r
bura66139532bura
burr65631232burr
car59165562_car
char95132152char
cur56841982cu_r
curr65429652curr
czar156013132czar
dear55343602dear
duad66521412duad
dual55928172dual
dura55232112dura
durr55624352durr
ear36867882_ear
eggar7458882eggar
far67762602_far
fear75337792fear
feuar8310242feuar
fiar76427332fiar
fubar1039922fubar
fur66637322fu_r
gab67155992g_ab
gad57556652g_ad
gae46457702g_ae
gag57753632g_ag
gal46055512g_al
gam67060062g_am
gan48060122g_an
gap67055612g_ap
garb75332672g_arb
gars55750742g_ars
gas48870252g_as
gat46880512g_at
gaud67025432gaud
gaum75726422gaum
gaun56427712gaun
gaurs66317992gaurs
gay76856492g_ay
gazar154612982gazar
gears64628692gears
ghat86435282ghat
glad65624012glad
glair65313552glair
glam76529342glam
glare65222952glare
glary96018542glary
gluer65116772gluer
gnarl65115572gnarl
gnarr64810692gnarr
gnars66718852gnars
gnat56034432gnat
gnaw86515742gnaw
goa47343802goa_
goad66830982goad
goal55829302goal
goas55239942goas
goat56250832goat
goer56827102goer
gor47848262g_or
grab75427612grab
grad66829862grad
gram77034582gram
gran56335012gran
grat55651282grat
gray85329892gray
guaco85012162guaco
guano69213982guano
guans64419442guans
guards84611562guards
guava938582guava
guck114922532guck
gude65423332gude
guff114624932guff
guid66022822guid
guiro63712092guiro
guitar7117442guitar
gul45832792gu_l
gulag7310822gulag
gulf84929422gulf
gull54828452gull
gulp75521362gulp
guls55930852guls
gum67439532gu_m
gums75030942gums
gun47240802gu_n
gunk95423572gunk
guns55533482guns
gurry94515412gurry
guru54623912guru
gush85424002gush
gust55240702gust
gut46753852gu_t
guts56637252guts
guv74523172gu_v
guvs85816812guvs
guy75728942gu_y
guys85019642guys
haar77323492haar
hear76143882hear
hoar76729162hoar
izar136616012izar
jaguar1435282jaguar
jar107646152_jar
jura116024892jura
kbar106514652kbar
knar85818722knar
kyar116916842kyar
lar37967532_lar
lear47045952lear
liar47229682liar
luau44824162luau
lunar57017312lunar
maar66025052maar
mar57965942_mar
mura65633292mura
murr65225132murr
near45236502near
oar37057952_oar
osar46820952osar
our36042892ou_r
par57467022_par
pear69745232pear
pur56840552pu_r
purr64925812purr
qua124821972qua_
quad144618702quad
quag144815942quag
quai134420392quai
quare143920542quare
quark184614122quark
quart144027852quart
quay164618352quay
rear45644552rear
roar46328572roar
ruer46127562ruer
scar66434202scar
sear47353842sear
soar46838672soar
spar65433302spar
star48037762star
suer45334032suer
sugar6312912sugar
sura45740292sura
tar37570692_tar
tear45242882tear
tsar47819802tsar
tzar136315372tzar
var66148332_var
war67262422_war
waur76819902waur
wear75836722wear
yar67253832_yar
year76534252year
yuan76120012yuan

Search took 2 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 Filter178691298720.1231452772.4
2DLD Change Limit298721740.95331345.2
3Display Results1741740.0463782.6
 (SQL Overall)1786911741.122159261.1
 
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.