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

165 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
gyp9831901(None) 
gap67055611gap
gip67645361gip
gym95719061gym
gyps105115021gyps
hyp117822461hyp
alp56641132alp
amp77541022amp
app76827602app
asp57235342asp
ay511773892ay_
aye67151762aye
ays67050292ays
bap76455842bap
bop77549482bop
by77529232by_
bye86134592bye
bys85229462bys
cap76758982cap
cep75736332cep
cop711162372cop
cup76738242cup
dap66652452dap
dip67848982dip
dup67637882dup
dye75334842dye
eye65539772eye
fop86743702fop
gab67155992gab
gad57556652gad
gae46457702gae
gag57753632gag
gal46055512gal
gam67060062gam
gamp98833212gamp
gan48060122gan
gape75134512gape
gaps76042972gaps
gapy106320912gapy
gar47259902gar
gas48870252gas
gasp76227332gasp
gat46880512gat
gawp107618632gawp
gay76856492gay
gays87338022gays
ged57044532ged
gee45359202gee
gel45642432gel
gem66840222gem
gen45950512gen
get47467462get
gey75738302gey
ghi77019882ghi
gib66443522gib
gid57047262gid
gie47149542gie
gig56040752gig
gimp96124042gimp
gin46055752gin
gips75632922gips
git46266052git
glop76724632glop
glyph1456472glyph
gnu45522042gnu
go38748742g_o
goa47343802goa
gob68950892gob
god57449792god
goo47754772goo
goop75829482goop
gor47848262gor
gorp75625902gorp
gos47155132gos
got49870442got
gox117137182gox
goy77844552goy
goys86328412goys
grip76127022grip
gul45832792gul
gulp75521362gulp
gum67439532gum
gun47240802gun
gut46753852gut
guv74523172guv
guy75728942guy
guys85019642guys
gybe105916242gybe
gyms107514592gyms
gypsy14636992gypsy
gyre84722762gyre
gyri85415152gyri
gyro85217882gyro
gyve116215082gyve
hap87360052hap
hep86644142hep
hip86750432hip
hop87554592hop
hup86437812hup
hype125519812hype
hypo127516352hypo
hyps125418412hyps
imp76626962imp
kep96437202kep
kip97042132kip
kop97440202kop
kye107327272kye
lap58565272lap
lip514755802lip
lop58255312lop
lye66533412lye
map77255112map
mop76950822mop
my78125652my_
myc106519502myc
nap56753202nap
nip56945982nip
op45850162_op
oy58950132oy_
pap76758402pap
pep76447082pep
pip78051042pip
pop76252252pop
pup76339882pup
pya87023752pya
pye86432502pye
pyx157817012pyx
rap56261962rap
rep55847802rep
rip56851302rip
rya67622012rya
rye66032542rye
sap56463232sap
sip57656012sip
sop57557862sop
spy86023742spy
sup57041942sup
syn67024122syn
syph125413272syph
tap57663872tap
tip56551222tip
top510560682top
tup56037542tup
tye65837442tye
type96223742type
typo95418122typo
typp115812782typp
typy126013042typy
ump76130442ump
up47832822_up
urp56426392urp
wap86553372wap
wop87145132wop
wye96331972wye
wyn95921442wyn
ya510251502_ya
yap85949822yap
ye57650062_ye
yep86638962yep
yip87241172yip
yo59748552_yo
yup86031702yup
zap145840692zap
zep147129142zep
zip146636222zip

Search took 1 second 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 Filter178691140840.1101624463.6
2DLD Change Limit140841650.72019561.1
3Display Results1651650.0602750.0
 (SQL Overall)1786911650.890200776.4
 
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.